Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a ComboBox dependent on another?
I am trying to set a ComboBox to list values dependent, on what was
selected on an earlier ComboBox. Private Sub ComboBox2_Change() Select Case Comboxbox1.ListIndex Case 0 'Operator Interface ComboBox2.AddItem "Pushbutton" 'ListIndex = 0 ComboBox2.AddItem "Selector Switch" 'ListIndex = 1 ComboBox2.AddItem "Cam Switch" 'ListIndex = 2 ComboBox2.AddItem "Foot Switch" 'ListIndex = 3 End Select End Sub But it doesn't seem to be happy with my approach, I get Run-Time error '424': Object Required. Am I missing something simple, or is this approach incorrect, is there another way? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
How can I make a cell a certain color dependent on number value? | Excel Discussion (Misc queries) | |||
Dependent combobox | Excel Programming | |||
Help me make a function dependent on current sheet?!? | Excel Programming | |||
how to make macro not dependent on datafile which has date as its part. | Excel Programming |