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.

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.