ActiveX combobox
hi, !
it's not so clear what you really try to do @ enter into combobox11 -?-
try adding a line with ComboBox11.Clear in your ComboBox10_Change event -?-
hth,
hector.
__ OP __
I am using activeX to create both my combobox and buttons.
I have 2 comboboxes. Combobox11 is dependent on combobox10. My program is as follows:
Sub Combobox10_enter()
Me.ComboBox10.Clear
Me.ComboBox10.AddItem (Sheets("Input").Range("M57"))
Me.ComboBox10.AddItem (Sheets("Input").Range("M58"))
Me.ComboBox10.AddItem (Sheets("Input").Range("M59"))
Me.ComboBox10.AddItem (Sheets("Input").Range("M60"))
End Sub
Sub Combobox11_enter()
If Me.ComboBox10 = Range("M60") Then
Me.ComboBox11.Clear
Me.ComboBox11.AddItem (Sheets("Input").[N59])
Else
Me.ComboBox11.Clear
Me.ComboBox11.AddItem (Sheets("Input").Range("N57"))
Me.ComboBox11.AddItem (Sheets("Input").Range("N58"))
End If
End Sub
Is there a way such that when I make changes to combobox10, combobox11 automatically gets reset.
Right now it still shows the last option selected.
|