View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Is it possible to send a "variable" to a userform text box?

hi
use the inputbox method ie....
dim v as string
v= inputbox("enter something")
textbox1.value = v

since you didn't post any code, i'm not sure just how you would work it in.
look up inputbox in vb help for more info.

Regards
FSt1

"Chet" wrote:

I have previously sent fixed values to a userform text box but is it
possible to have my code take some user input then feed that user
input to a userform text box during the same run of the code? In
other words my text box could say "Program will run for location xxxx"
where xxxx is the variable that can change with each run of the code?

Thanks,
Chet