Run-time error '424' in VBA event handler on XL shutdown
Unlink the comboboxes from your worksheet cells and handle this with code in
the change event.
--
Regards,
Tom Ogilvy
"Mike Jones" wrote in message
...
This is getting aggravating! I have several combobox change event
handlers.
They work fine most of the time. But at shutdown, for some reason these
event handlers are firing (which is odd, since the app is shutting
down...I
don't care if they've changed at that point). The event handlers run, but
when they get to the combobox objects, they are "empty" and I get the 424
exception.
Am I supposed to be checking some property that says the app is shutting
down or something?
|