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


"GH" wrote in message
oups.com...
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?