variable that keeps its value until reset

[Jamie Martin]

Hi,

How can I declare a variable that will keep its value not only after a
procedure is run, but when Excel or the computer is shut down--that will
keep its value until it is reset?

THanks,

Jamie

 

[Robin Hammond]

Jamie,

You would have to store it in the registry or write it to a text file.

Have a look at help on SaveSetting and GetSetting.

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

 

[bruce]

The place you might be thinking of storing your variable
might be within your VBA code. This can be done and it
might best be stored in a little two line routine that can
be called as required.
Self modifying code is possible but you will have to
search the internet or MS Knowledgebase for a good lead.