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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,219,096
Messages
6,146,273
Members
450,682
Latest member
augusto89

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
Back
Top