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

vba excel activexobject
Madhan picture Madhan · Mar 31, 2015 · Viewed 22.9k times · Source

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.

Answer

kolcinx picture kolcinx · Mar 31, 2015

ComboBox_Click() is the event you are looking for.

Related questions

Excel 2010 ActiveX Controls No Longer Working After Windows Updates

So at work I ran into this issue after I installed the most recent Windows 7 updates (including Microsoft Office 2010 updates) - the date up the update was today (Dec 12, 2014). After the update, I opened my macro enabled workbook in Excel 2010 …

Read More
Corrupted ActiveX control? "Can't exit design mode because Control 'DTPicker1" can not be created"

I am developing an Excel VBA application on my desktop machine. I have a DatePicker ActiveX control on my spreadsheet. It was working fine. Then, while on travel, I was working on the application on a laptop. When I returned, …

Read More
Uncheck all checkboxes across entire workbook via CommandButton

I would like to have a code that unchecks all checkboxes named "CheckBox1" for all sheets across the workbook. My current code unfortunately doesn't work, and I'm not sure why - it only works for the active sheet. Private Sub …

Read More