ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Vba - getting value from other userform (https://www.excelbanter.com/excel-programming/308288-vba-getting-value-other-userform.html)

ajliaks[_33_]

Vba - getting value from other userform
 
Hi all,

in Userform1 I have TextBox1
I need to use that value into userform2. How do I call that value fro
Userform2?

something like...
Text= Userform1(TextBox1.value) ???

Thanks,
Aldo

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Vba - getting value from other userform
 
vVar = Userform1.Textbox1.Value

--
Regards,
Tom Ogilvy

"ajliaks " wrote in message
...
Hi all,

in Userform1 I have TextBox1
I need to use that value into userform2. How do I call that value from
Userform2?

something like...
Text= Userform1(TextBox1.value) ???

Thanks,
Aldo.


---
Message posted from http://www.ExcelForum.com/




Bob Phillips[_6_]

Vba - getting value from other userform
 
Text= Userform1.TextBox1.Text

Be aware that if Userform1 has been unloaded, the textbox will have been
cleared.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"ajliaks " wrote in message
...
Hi all,

in Userform1 I have TextBox1
I need to use that value into userform2. How do I call that value from
Userform2?

something like...
Text= Userform1(TextBox1.value) ???

Thanks,
Aldo.


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 02:10 AM.

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