Static Variables

[JohnAcc]

Hi There,

I need to declare a static variable and i am not sure where to declare this. At present i am declaring it in a seperate module within the workbook but i have 7 or 8 modules that need to use this variable.

It currently says "invalid - outside procedure"

Any help would be appreciated.

Cheers

John

 

[VBAva]

hey John

You cannot have a public static variable, statics are a special type of Local variable.

unfortunatly i dont know a way around this problem, sorry :-(

Ava

 

[JPMontreal]

Hi,

If you declare a public variable in the general section of a module, it keeps his value, like a static variable, as long as the Excel book, where it was created, is open.


Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca