VBA variables lifespan ^ scope

If you dislike perl's strictVars, then skip --

OptionExplicit must be declared in each module. Like perl strictVars. VBE -} menubar -} tools -} options -} editor tab -}RequireVariableDefintion would insert OE in every new module.


--var Scopes
* procedure-scope, where "procedure" also includes functions. Remember the "Locals" window.
* module-scope? shared among procedures within the module. Less popular
* public? global, across modules.
* There might be other scopes but less used. I'd say procedure scope and public are the most used.

--var lifespan is a less commonly used feature.
Look at "staic" variables -- just like C.

When a macro completes, static/module/public variables will keep the residual value whereas procedure variables are destroyed.