The Multi Page tool

[mortgageman]

I'm a bit shaky on the Multi Page tool (Oh heck, I'm shaky on most stuff), so this question may be born of ignorance:

Once you have designed a User Form, is it too late to use the multipage tool to create a "second" page? When I use the tool, it puts two pages on the existing userform - which of course is not what I want.

Big Picture of what I want: Right now I have a User Form that does a pretty good job of solving 2 or 3 equations. I would like to add a button that when pressed will "take" the user to a User Form that can multiply matrices. I had thought the multipage tool would be the way to go, but as you can see from above, I may have wrong.

Any suggestions or ideas would be mucho appreciated.

Gene, "The Mortgage Man", Klein

 

[Greg Truby]

You can add a page at run time. But you would then also have to add any controls etc. Better to just build what you need in the VBE at design time and then toggle the page's VISIBLE property:

Private Sub CommandButton1_Click()
    Me.MultiPage1.Pages(3).Visible = True
End Sub

Private Sub CommandButton2_Click()
    Me.MultiPage1.Pages(3).Visible = False
End Sub

Private Sub CommandButton3_Click()
    Me.MultiPage1.Pages.Add
End Sub

 

[mortgageman]

I confess I don't see how to use your code if I am in mid design already.
How do you "add a page at run time"?

Gene, "The Mortgage Man", Klein

 

[Joe Was]

Stretch your UserForm, Move all your controls to the bottom, add the MultiPage control up-Top on your form, cut/paste or move your controls to the multipage. Shrink the form back down.

 

[mortgageman]

Stretch your UserForm, Move all your controls to the bottom, add the MultiPage control up-Top on your form, cut/paste or move your controls to the multipage. Shrink the form back down.

Thanks - I'll try and let you know how it works.

Gene, "The Mortgage Man", Klein