What event is triggered when user selects value from drop down ComboBox (ActiveX)?

4
votes

What event is triggered when user selects value from drop down ComboBox (Active X). How it can be defined in VBA. I would like to trigger macro when value is selected from drop down.

2
vbaexcelactivexobject
ComboBox_Change event is triggered when a user selects a value. ActiveX have their own events you can use to run routines. I see you have previous questions related to this as well. Might as well add illustration or screen shot of your issue or what you're trying to achieve. That will add clarity and will attract more answers. – L42
Combobox_change event triggered as soon as i started to type. (Auto search drop down). So cannot use this property to trigger event. I am using ActiveX combo box – Madhan
It has to be like when user selects value from drop down then move focus to next drop down else show msg:"Select value from drop down" – Madhan

2 Answers

2
votes

ComboBox_Click() is the event you are looking for.

0
votes

If you're using a ComboBox control in a UserForm, it usually have an AfterUpdate Event.
If you're using an ActiveX Control ComboBox in a Sheet, you can try LostFocus Event.

Private Sub ComboBox1_LostFocus()

End Sub

This way, you can type in values and then run the routine after you select another object.