Declaring Variables

B

Brad

Thanks for reading my question

I have a user form that has a text box on it. I would
like to save the value of that text box to a variable
that I can use in another module. I know in MS Access
you can create a Global type variable.

How is this done in Excel?

Thanks again,

Brad
 
B

Bob Phillips

Create a variable in a standard code module, not the form code module, and
declare it as Public

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

Thank you so very much!

It worked perfectly

Brad
-----Original Message-----
Create a variable in a standard code module, not the form code module, and
declare it as Public

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Top