Where For Art Thou DIM?

  • Thread starter Thread starter GH
  • Start date Start date
G

GH

I have a userform that during initialization, deminsions a number of
variables (as Long). These variables store simple arithmatic
calculations. I need to refer to these variables as the user clicks
certain buttons on the form (i.e. code activated with the on click
event). If the variables are DIMed in the initialization of the form,
how should I call these values within the on click events? I really
don't want to declare them globally as they only are used relative to
this userform (it is actually a subform called from a main userform).
Do I have to pass the variables?
 
If they are Dim'd in the Initialize event procedure of the form,
they will be destroyed when that procedure ends. The only way is
to declare them as Public or Private.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
just to add, when you declare/dim them as Private at the top of the userform
code module (outside any procedure), they only exist as long as the userform
is loaded. They are also only accessible to the code contained in the
userform code module.
 
Back
Top