Qn: Setting MultiPage page default???

  • Thread starter Thread starter Michael Vaughan
  • Start date Start date
M

Michael Vaughan

I have set up a UserForm with a MultiPage function to be used as a menu. I
have about 5 different Sheets in my workbook, and so I use the same UserForm
on ALL sheets to bounce around like a menu. One problem, everytime I click
on menu and my userform comes up.. It always defaults to the same page
(Page 5) on the MultiPage. Is there anyway to set the Current Page that you
are on when you exit to unload it so that when I click on menu again, it
focuses on Page 3 now instead of Page 5 all the time???

Thanks.. mv
 
Hi Michael,

Try something like:

Private Sub UserForm_Initialize()
MultiPage1.Value = 2 ' Zero-based, activates page 3
End Sub
 
Hi Norman,

Well, I didn't think about using the Initialize method. I had to modify it
a little bit, but that did the trick!!!

Thanks a million... mv
 
Back
Top