View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?