Multiple UserForms

[sgrzzl]

I have several UserForms that I am using to input data into specific worksheet cells or ranges using the following:

Private Sub ContactTitle_Change()
Range("Contact_Title") = ContactTitle.Value
End Sub


I have Next and Back buttons on each UserForm. Everything is working great except when I use the back button it Unloads the current Userform and Loads the previous form and all the fields are blank.

When I press the back and the previous form appears I would like the fields to to display the information that I have already entered into the form and stored in my worksheet.

 

[HalfAce]

Welcome to the board.
How are you dismissing these userforms before calling them back up with your back button?

If you dismiss a UForm by using the Unload UserForm1 method, it unloads and requires re-loading when called back up.

If you dismiss a userform using the UserForm1.Hide method, it will dismiss the userform (as far as the user is concerned) but it will be retained in memory - with all fields still filled in. (Thus, when you recall it with the back button your previous data will still be present.)

Does that help?

 

[GTO]

Sorry to ask a question rather than offer a solution, but why the need for multiple forms? Have you tried the Multi-Page control? You could hide the tabs and still use PRevious, Next <NEXT>buttons.

 

[sgrzzl]

Welcome to the board.
How are you dismissing these userforms before calling them back up with your back button?

If you dismiss a UForm by using the Unload UserForm1 method, it unloads and requires re-loading when called back up.

If you dismiss a userform using the UserForm1.Hide method, it will dismiss the userform (as far as the user is concerned) but it will be retained in memory - with all fields still filled in. (Thus, when you recall it with the back button your previous data will still be present.)

Does that help?

Thanks! That works.

 

[sgrzzl]

Sorry to ask a question rather than offer a solution, but why the need for multiple forms? Have you tried the Multi-Page control? You could hide the tabs and still use PRevious, Next <NEXT>buttons.

I am using Multi-page controls on several linked UserForms for a Quote Generation tool.

 

[GTO]

Thank you for responding