Where For Art Thou DIM?
 

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?

Where For Art Thou DIM?
 

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?

Where For Art Thou DIM?
 

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.

--
Regards,
Tom Ogilvy



"Chip Pearson" wrote in message
...
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?

Where For Art Thou DIM?
 

Got it. Thanks for the quick response.