PDA

View Full Version : multiple form



RonMexico
05-01-2011, 05:36 PM
i have a macro with multiple forms. how to i read information from one form to another. for example if form1 has check boxes and radio buttons how do i read if whether or not the check box was selected and the radio button was selected in form3.

mikerickson
05-01-2011, 08:56 PM
The syntax should be similar to UserForm2.Checkbox3.Value.
But, once Userform2 is unloaded, the value of CheckBox3 is reset from the value set by the user to the default.

An alternative to multiple userforms is a userform with a MultiPage control.

RonMexico
05-02-2011, 07:37 AM
The syntax should be similar to UserForm2.Checkbox3.Value.
But, once Userform2 is unloaded, the value of CheckBox3 is reset from the value set by the user to the default.

An alternative to multiple userforms is a userform with a MultiPage control.

is there a way to keep the information; i have never use the multipage control before and i don't know if the program will have the same feel to it. right now i have buttons, and based on whether or not those buttons are clicked, a different form will show up. can i do that with multipage

RonMexico
05-02-2011, 07:49 AM
update.....i am not unloading the forms, but hiding them

mikerickson
05-02-2011, 12:00 PM
The syntax for reading the value of a userform's control would be the same.

RonMexico
05-02-2011, 06:19 PM
thank you all