accessing variant after macro has ended

[RAYLWARD102]

I have a public variable declared in a Module, that's triggered by worksheet change event; My public variable ceases to exist after the Module subroutine completes. How do I preserve a Public variable in memory, for use later on? Is there a way? Basically want to be able to retrieve that variable without after an extended amount of time has passed, where the user is not running any macros (just using the workbook sheets) until the change event occurs once again.


EDIT:
basically want a non-expiring variable; one that remains active until workbook project is closed.
I did read about ActiveWorkbook.CustomDocumentProperties, but these properties can't seem to store an array (variant)

 

[rlv01]

- An ActiveX control is added to any sheet in the workbook containing the VBAProject (!)

Do you mean the presence of an ActiveX control on any sheet, or the action of programatically adding one?

 

[Jaafar Tribak]

Do you mean the presence of an ActiveX control on any sheet, or the action of programatically adding one?

Only when adding the ActiveX control at runtime because it resets the VBE and all values stored in variables are released

 

[Jaafar Tribak]

Oh, and "HI!" to Jaafar. Nice to see you again, my old friend.

Nice to see you dear Greg