Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declaring variables | Excel Discussion (Misc queries) | |||
Declaring Variables | Excel Programming | |||
DEclaring variables | Excel Programming | |||
DEclaring variables | Excel Programming | |||
Declaring Variables | Excel Programming |