Posted to microsoft.public.excel.programming

Alan Beban[_2_] Alan Beban[_2_] is offline

external usenet poster

Posts: 783

Lifetime of VBA variables

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
scope/ lifetime of variable	jeffP	Excel Programming	5	September 19th 04 05:25 AM
scope/ lifetime of variable	Norman Jones	Excel Programming	0	September 18th 04 12:55 AM
!!!! A chance of a lifetime !!!	Good	Excel Programming	0	June 3rd 04 06:14 AM
!!!! A chance of a lifetime !!!	Good	Excel Programming	0	June 3rd 04 06:14 AM
module-level variable lifetime	Jessie[_2_]	Excel Programming	0	July 30th 03 09:31 PM

All times are GMT +1. The time now is 02:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us