View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Learn-more Learn-more is offline
external usenet poster
 
Posts: 25
Default 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