Hello Excel Forum,
I have a worksheet that contains an ActiveX ComboBox, for which I have written some code to populate the drop-down list:
This code was working as intended earlier in my project's development but now the event doesn't even trigger; I've tested this by placing a breakpoint in the first line of code but the debugger does not open. This piece of code is unchanged from when it was working.Please Login or Register to view this content.
I've looked around the VBE environment and have tried searching online for potential issues, but I cannot find the reason the code is no longer executing (as if the control is not receiving focus). Does anyone have any idea as to why, typically, a form control (on a worksheet) may stop receiving focus?
All suggestions will be very much welcomed!
Thanks
Andrew
Bookmarks