Drop Down List

S

Snakeoids

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
 
D

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.)
 
Top