i have a macro with multiple forms. how to i read information from one form to another. for example if form1 has checkboxes and radio buttons how do i read if whether or not the check box was selected and the radio button was selected in form3.
Printable View
i have a macro with multiple forms. how to i read information from one form to another. for example if form1 has checkboxes and radio buttons how do i read if whether or not the check box was selected and the radio button was selected in form3.
By using the names of the forms along with the objects from that form...
I assume you are just using VBA from within an Office application.Code:Userform1.TextBox1.Text
Userform2.TextBox1
Userform3.CheckBox
i have tried that but i don't get any value. lets say that the user input their name in userform1.NameTextbox. when i want to retrieve that information on userform3, i don't get any value.Quote:
Originally Posted by nO_OnE
Have you closed the 'userform1' form? Once you close a form, the data is gone.Quote:
Originally Posted by RonMexico
thankx mark, i went back to view the code and i saw that i unloaded it instead of hiding the form