Can't Trigger a Macro When a ComboBox is Changed
I inserted a standard Excel combo box form control in a worksheet. I'm trying to trigger a macro when this value is changed, but I can't get Worksheet_Change(ByVal Target As Range) to recognize the action/change. I tried multiple things, and currently have;
But like I said the code isn't even being triggered when the box is changed. What am I doing wrong? Thanks!
Please Login or Register to view this content.
Worksheet_Change only works for cells, not controls.
If you want a Form control to trigger a macro, right-click on the control and then Assign Macro.
you need to assign a macro to the form control (see module) - gives the actions on the sheet.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
That worked, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks