Drop Down List

[Guest]

Greetings,
I have an Excel document that has a couple of drop down list controls, but
no values in them. How do I create values for these drop down lists? Thank
you.
Rod

 

[Debra Dalgleish]

If the dropdowns are data validation lists, you can follow the
instructions here:

http://www.contextures.com/xlDataVal01.html

If the drop downs are combo boxes from the forms toolbar or the control
toolbox, you can enter an Input Range or ListFill range

 

[Dave Peterson]

I think that the answer depends on what the DropDowns are:

Data|Validation
See Debra Dalgleish's site:
http://www.contextures.com/xlDataVal01.html

DropDown from the Forms toolbar
rightclick on it
select Format control
Control tab
Point at a nice range

Combobox from the Control Toolbox Toolbar
rightclick on it (while in design mode--also an icon on the control toolbox
toolbar)
select properties
Type in the sheetname!address of the range you want in the ListFillRange
property.

====
(Actually, the dropdown and the combobox can be filled in via code, too.)