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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Greg Truby

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

Forum statistics

Threads
1,144,619
Messages
5,725,331
Members
422,617
Latest member
rahul27ragit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top