Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables to be use by different Sub
In one Userform I had 2 Command Button calling 2 different Sub.
The first Sub will get input from Text Box and then store in cell A3, eg Range("A3") = txtVal1.Text How can I use the last txtVal1 and use it in the second Sub which was called from another Command Button and under a second Userform. Basically, I could not work out where and how I can declare the variable so it can be use commonly in differen Sub in different Userform etc. Thanks for helping. Learn-more |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum if 2 variables | Excel Discussion (Misc queries) | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Storing variables in a macro and using those variables to performcalculations. | Excel Programming | |||
Variables | Excel Programming | |||
Variables | Excel Programming |