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
|