Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking a ComboBox
I have list of four Options in a user form that are for the most part "grayed
out" When a condition is met those Options become enabled. I am trying to use a single ComboBox to indicate how many pieces of that product can be used. Is there a way to make a single ComboBox work for the four Options or do I have to create four ComboBoxes and link them to each Option. Another way I thought of doing it is by setting the ControlSource to be something like L209 and writing a formula in the worksheet to use L209 in a If statement, but that seems like an extra step that may not be needed. Any Ideas on how to go about this would be much appreciated. Thanks for everyones help so far. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
ComboBox, linking cells, vba, worksheetchange function, and overal frustration | Excel Programming | |||
Combobox items determined by the selection in another combobox | Excel Programming | |||
Combobox options based on the input of another combobox | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming |