Someone please set me straight or confirm my understanding.

If I declare a variable as Public in any standard module, in the
Declarations section, then that variable can be accessed by any subroutine
in any standard module, AND any userform module. Right? What about the
ThisWorkbook module or individual sheet modules?

Concerning custom user forms: Loading the form into memory executes the
Initialize event (not the Activate event) of the form, correct? If so, then
this might be a good place to indicate to whatever subroutine that might be
interested that the form is now in memory. And unloading the form resets
whatever was done during Initialization, right?

Is there a Forms collection by which I can cycle through all loaded forms?

Thanks!

-gk-