Thread: userforms
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default userforms

One trick is to make an invisible text box on one userform and use it to
store variables that need to be passed.

"ranswrt" wrote:

I have 2 userforms set up. How do I pass a value from one userform to the
other?
In userform1 I set a "public item as string" variable, but it didn't pass
that value to userform2 when it called userform2.

Thanks