Lookup lists
Posted: Sun Jan 19, 2014 11:37 am
I've got some code to implement lookup lists, but either its not complete or not correct:
My code:
This code correctly puts the settings for Data Validation in Excel for cell $A$1, but the dropdown arrow (combobox) is missing, and needs to be manually selected in Excel in the Data Validation dialog box.
If someone could help me by pointing what is required to do additionally to get this working, I'd be grateful.
TIA.
My code:
Code: Select all
dv := xlsreadwrite.Sheets[0].Validations.Add;
with dv do
begin
Formula1 := '$R$275:$R$276';
Sqref.Add(0, 0);
ShowDropDown := True;
Type_ := x12dvtList;
AllowBlank := False;
end;
If someone could help me by pointing what is required to do additionally to get this working, I'd be grateful.
TIA.