Drop Down List
 

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

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

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

Snakeoids wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I think that the answer depends on what the DropDowns a

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

Snakeoids wrote:

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

--

Dave Peterson