Posted to microsoft.public.excel.programming
|
|
Lifetime of VBA variables
Jim Thomlinson wrote:
They retain their value for as long as the workbook is open... The same is
true of static variables...
Thank you.
Alan Beban
"Alan Beban" wrote:
I use VBA with Excel; I do not use VB.
My Visual Basic User's Manual says that Module-level variables retain
their values while Visual Basic is running. Does that mean as long as
Excel is open? Or as long as an Excel workbook is open? Or something else?
Thanks,
Alan Beban
|