Declaring Variables
 

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

Declaring Variables
 

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

Declaring Variables
 

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)

"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


.

Declaring Variables
 

It's a pleasure.

--
HTH

-------

Bob Phillips
wrote in message
...
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)

"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


.