Passing Variables
 

I have defined two variables (both strings) in the code
for a userform and need a sub outside the userform to be
able to use the information, so I need to pass both
variables to that macro. Unfortunately for me, I can't
remember how to do that! Any help would be appreciated.

Passing Variables
 

In your main module put

Public strVariable as String

RBS


"Paula" wrote in message
...
I have defined two variables (both strings) in the code
for a userform and need a sub outside the userform to be
able to use the information, so I need to pass both
variables to that macro. Unfortunately for me, I can't
remember how to do that! Any help would be appreciated.