ActiveX combobox
 

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.
Thanks.

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.