Declaring Variables

[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

 

[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)

 

[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)




.

 

[Bob Phillips]

It's a pleasure.

--
HTH

-------

Bob Phillips

Thank you so very much!

It worked perfectly

Brad