How to get Workbook_SheetChange code to run from a ComboBox dropdown linked cell

[Warfarin]

I've seen a bunch of posts surrounding this and I understand it's because, I think, the SheetChange event never happens when using the Form Control Dropbox. This code was originally written for the Data Validation dropdown but it turns out people want to see the actual dropdown arrow. How can I get this VB code to recognize what option that was selected in the control dropbox?

Please Login or Register  to view this content.

Thank you

[Norie]

How about using the combobox's own change event?

Please Login or Register  to view this content.