ActiveX change event firing in sheet destructor when object already out of scope

Hi all,

I have several ActiveX combo-boxes on a sheet. Each one has code for the change event, so an update to the first automatically fills the next boxes with appropriate values. So far, so good. It works as intended.

But when I close the workbook a change event gets fired. By the time it is processed however, the ActiveX objects the event should act on do no longer exist. So I get a compilation error on statements like

Please Login or Register  to view this content.

. Because it is a compilation error, I cannot trap it with

Please Login or Register  to view this content.

.

I tried setting a global flag in

Please Login or Register  to view this content.

and various other places, but it seems the event is passed the value of that flag as it was when triggered, which is before

Please Login or Register  to view this content.

. By the time it actually starts processing the event my Debug.Print statement says we passed

Please Login or Register  to view this content.

and the flag is set. But the check in the change event (

Please Login or Register  to view this content.

) says not. So the event continues to the routine doing the actual work, and raises an error on the

Please Login or Register  to view this content.

code.

Any suggestions are welcome, this is driving me nuts.

Yours,

André

Romperstomper,

I have to use the ActiveX version, for they expose some properties that the build in combobox lacks. But your solution works! Thanx a million.

André