Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional lists for a Combo Box
I want to create a Combo Box that will display 1 of 6 lists once a condition
is met, kind of like an IF statement. I have two Combo Boxes. The first displays the same list all the time - no problem. I want the second Combo Box to display 1 of 6 lists depending on what was selected in the first Combo Box. Is this possible? If so, can someone explain how to do it. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional lists for a Combo Box
Mike,
Take a look here at creating dependent lists using data validation: http://www.contextures.com/xlDataVal02.html HTH "Mike" wrote: I want to create a Combo Box that will display 1 of 6 lists once a condition is met, kind of like an IF statement. I have two Combo Boxes. The first displays the same list all the time - no problem. I want the second Combo Box to display 1 of 6 lists depending on what was selected in the first Combo Box. Is this possible? If so, can someone explain how to do it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box, List box, Validation | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |