ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   passing control value from one form to another form (https://www.excelbanter.com/excel-programming/294021-passing-control-value-one-form-another-form.html)

Mark Kubicki

passing control value from one form to another form
 
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



Vasant Nanavati

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






All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com