Working with 2 drop down list
Kim,
Something to try (untested)...
Set a Public Variable
---------------------
Public StopMe as Boolean
Private Sub ComboBox1_Change()
StopMe = True
' code to update ComboBox2
StopMe = False
End Sub
Private Sub ComboBox2_Change()
If StopMe = True Then Exit Sub
' combobox2 code
End Sub
--------------------------
John
"Kim" wrote in message
...
I have 2 drop down list on my spreadsheet. #1 is the master and #2 is
based
on selection from #1.
For example: if a user select "Auto" in list #1, then in list #2, only a
list of Auto will be filled in.
My question is when I select a value in List#1 it automatically run both
subs combobox1_change and combobox2_change. It doesn't allow the user the
select the drop down list #2.
Can someone help me so that only sub combobox2_change runs only when drop
down list #2 is selected.
Thanks
|