The Multi Page tool

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
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:
Code:
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

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
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

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
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

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,040
Messages
5,545,676
Members
410,697
Latest member
srishtijain0708
Top