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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a ComboBox dependent on another?
I would use the click event, but as far as the error - that usually indicates
an invalid object since "Comboxbox1" appears to be misspelled I would look there first. -- Regards, Tom Ogilvy " wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a ComboBox dependent on another?
Quote "since "Comboxbox1" appears to be misspelled" This is a good
reason to require "Variable Declaration". In the VB editor goto Tools... Options... and check "Require Variable Declaration". This places "Option Explicit" at the top of every new code page, requiring that you dim variables otherwise you will receive a compile error. Basically it's a spell checking service for me. Charles xl Geek Tom Ogilvy wrote: I would use the click event, but as far as the error - that usually indicates an invalid object since "Comboxbox1" appears to be misspelled I would look there first. -- Regards, Tom Ogilvy " wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a ComboBox dependent on another?
Thanks all, thats all it was, works fine now. I wonder how long I
would have slaved over this, when the whole time it was just a mispelling. Die_Another_Day wrote: Quote "since "Comboxbox1" appears to be misspelled" This is a good reason to require "Variable Declaration". In the VB editor goto Tools... Options... and check "Require Variable Declaration". This places "Option Explicit" at the top of every new code page, requiring that you dim variables otherwise you will receive a compile error. Basically it's a spell checking service for me. Charles xl Geek Tom Ogilvy wrote: I would use the click event, but as far as the error - that usually indicates an invalid object since "Comboxbox1" appears to be misspelled I would look there first. -- Regards, Tom Ogilvy " wrote: 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 |
Reply |
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 |