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 |
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/ |
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