Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '424' in VBA event handler on XL shutdown
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '424' in VBA event handler on XL shutdown
Sorry, I'm unsure what unlinking it from the worksheet cells means. I've
gone into "Format Control" and selected "Don't move or size with cells", which lowered the number of problems, but I'm still having issues. I am not using "Linked Cell". "Tom Ogilvy" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '424' in VBA event handler on XL shutdown
Never had a problem with this if the comboboxes aren't linked to cells.
Can't imagine what would cause your comboboxes to change and fire your change event macros. -- Regards, Tom Ogilvy "Mike Jones" wrote in message ... Sorry, I'm unsure what unlinking it from the worksheet cells means. I've gone into "Format Control" and selected "Don't move or size with cells", which lowered the number of problems, but I'm still having issues. I am not using "Linked Cell". "Tom Ogilvy" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_change event handler error | Excel Discussion (Misc queries) | |||
Error Handler Not working 2nd time | Excel Programming | |||
Compile-time Error Handler | Excel Programming | |||
Run-time error '424': Object required | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |