Worksheet_Change Event not firing

[dabrows]

Hey there - I am lost. I have a worksheet that has a dropdown list. Once I select something new from the dropdown list, a 'change' has occurred and should fire the code below. Unfortunately, when I invoke a change, I can't even get into my 'test' at the top of the code. I have the code written in the worksheet excel object and not a regular module (see photo). I have looked at the trust center settings and the Macros are set to 'Disable VBA macros with notification' and the Message Bar is set to 'Show the Message Bar in all applications when active content.....'.

Screenshot 2024-01-12 111619.png

I will also say that I simply tried opening the worksheet object and hitting F5 and I am getting 'Unexpected Error 35005'. Unfortunately, google hasn't helped me w/ that one either.

Any ideas? Thanks for the help!

Please Login or Register  to view this content.

[rollis13]

Your event macro looks like it is in working condition.
Check the state of the function Application.EnableEvents to see if it is True (in the Immediate pane (Ctrl+G if not visible) paste ?Application.EnableEvents and press Enter). If False paste Application.EnableEvents = True and press Enter then retry changes in the sheet.

[dabrows]

Your event macro looks like it is in working condition.
Check the state of the function Application.EnableEvents to see if it is True (in the Immediate pane (Ctrl+G if not visible) paste ?Application.EnableEvents and press Enter). If False paste Application.EnableEvents = True and press Enter then retry changes in the sheet.

I tried the ?Application.EnableEvents as you suggested and the result was True. Somehow, everything is now working. I have no idea how come.

[TMS]

This

Please Login or Register  to view this content.

is redundant.

If Events are not enabled the WSCEh will not fire so you won't have the opportunity to enable it and display a MsgBox.

[rollis13]

Somehow, everything is now working. I have no idea how come.

The issue probably occurred when the status of the event was False. This could have happened if the macro crashed and ended before resetting the event state via code. Then, if the file is closed and reopened, the event state is automatically reset to True. So, there's no need to close/reopen, just use the Immediate pane as I suggested above.