multiple form

**RonMexico** · May 1st, 2011, 07:37 PM

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.

**nO_OnE** · May 1st, 2011, 10:51 PM

By using the names of the forms along with the objects from that form...

Code:

Userform1.TextBox1.Text
Userform2.TextBox1
Userform3.CheckBox

I assume you are just using VBA from within an Office application.

**RonMexico** · May 2nd, 2011, 09:33 AM

Originally Posted by nO_OnE

By using the names of the forms along with the objects from that form...

Code:

Userform1.TextBox1.Text
Userform2.TextBox1
Userform3.CheckBox

I assume you are just using VBA from within an Office application.

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.

**MarkWalsh** · May 2nd, 2011, 10:20 AM

Originally Posted by RonMexico

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.

Have you closed the 'userform1' form? Once you close a form, the data is gone.

**RonMexico** · May 2nd, 2011, 10:35 AM

thankx mark, i went back to view the code and i saw that i unloaded it instead of hiding the form

Thread: multiple form

Thread Tools

Display

multiple form

Re: multiple form

Re: multiple form

Re: multiple form

Re: multiple form

Posting Permissions