View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default passing control value from one form to another form

Unless I'm missing something, exactly the same way you said:

UserForm1.TextBox1.value

Of course UserForm1 has to be open, even if hidden.

--

Vasant


"mark kubicki" wrote in message
...
how can, on UserForm 2,
i reference a value of a control on a different user form
(UserForm1.TextBox1.value) ?

...UserForm2 is always made visible by a command button on UserForm1