Userform: Show last viewed multipage on open

[anyroomforalittlechang]

Hello-

First time poster here.

I have a userform with 10 tabs currently and would like to know how to set it so that if I'm working on Tab1, close the Userform, re-initialize the Userform, it will open on Tab1 or whichever tab the user was last working on.

Currently hardcoding it as MultiPage1.value = 0 in the UserForm_initialize sub.

Or should I be adding the code in the Private Sub MultiPage1_Change() sub?

Thank you!

 

[GWteB]

Hi & welcome to MrExcel!

This can be done in two ways:
- store the number of the relevant page in a public variable in a module other than that of the userform before closing the userform, and use that variable for setting focus on the required page;
- leave the userform alive on closing and thus only Hide it, so that the userform is displayed in the state it was in when it was closed on a subsequent Show.

 

[anyroomforalittlechang]

Hi & welcome to MrExcel!

This can be done in two ways:
- store the number of the relevant page in a public variable in a module other than that of the userform before closing the userform, and use that variable for setting focus on the required page;
- leave the userform alive on closing and thus only Hide it, so that the userform is displayed in the state it was in when it was closed on a subsequent Show.

Awesome to be here, finally signed up and will definitely be active trying to learn more about VBA.

I managed to store the number on a different sheet upon userform termination, then called it back when it initialized.

Thank you @GWteB