Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Drop Down List | Excel Worksheet Functions | |||
formatting drop down list | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |