PDA

View Full Version : MultiPage in UserForm



msquared99
08-09-2012, 11:02 AM
I have a UserForm that has two MultiPages, Page1 (Tab name Pre-Work) the other Page2 (Tab name Talking Points). When the user finishes their entries on Page1 is it possible for them to just click on the Page2 tab to select it and enter data there? Then if they need to go back to Page1, to just click on the tab instead of creating a command button?

Also, since this is my first UserForm I assume I would need to use this:

MultiPage1.Value = 0 where I initialize the UserForm?

Guess my real question is I can enter data into Page1 of the MultiPage and export it to Sheet1 of the Workbook but cannot get to Page2.

I can post the code but it is long.

Thanks,

Mike

Tinbendr
08-09-2012, 12:18 PM
I'm only guessing that you have the multipage all the way down to the bottom of the userform. Bring the botton up and put a commandbutton at the bottom that processes all pages, regardless of which one has the focus.