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.
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.
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 multipageOriginally Posted by mikerickson
update.....i am not unloading the forms, but hiding them
The syntax for reading the value of a userform's control would be the same.
thank you all
Posting Permissions
Reply With Quote