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)

"Brad" wrote in message
...
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