I have an ActiveX Combobox control on a worksheet and this is the _Change
event code
Private Sub ComboBox1_Change()
Me.ComboBox1.ListFillRange = "ItemSearch"
Me.ComboBox1.DropDown
End Sub
When I use keyboard up/down key to move through the list it automatically quits Excel.
Does anyone know the solution to this problem? I basically want a dynamic ComboBox.