Multipages in a userform

willlobb

Board Regular
Joined
Mar 29, 2002
Messages
103
Can anyone help? If i have a userform with a multipage in it, and on the first page of the multipage i have a button, can i get the button (when clikced) to activate and goto the second page of the multipage?
i really need to know, thanks
This message was edited by willlobb on 2002-03-31 09:11
This message was edited by willlobb on 2002-03-31 09:28
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
You could try the following (Value can be from 0 to 1 less than the number of pages you have in your multipage):-

Private Sub CommandButton1_Click()

MultiPage1.Value = 1

End Sub

Not sure why you'd want to do this though?
 
Upvote 0
Thanks MudFace,
that worked, now is there anyway of getting it to go to the next page? ie page x. would it be possible to use the CStr thingy?
by the way, im making a financial system for my young enterprise company and i have a user form where you enter the no. of hours each employee has worked. each person is on a separate page of a multipage, so when you enter the first persons hours i want it to goto the next person automatically (if any of that makes sense!)
thanks
Will
 
Upvote 0
OK, the following will advance you through the pages one by one, then loop back to the first page when you reach the end: -

Private Sub CommandButton1_Click()

If MultiPage1.Pages.Count - 1 > MultiPage1.Value Then
MultiPage1.Value = MultiPage1.Value + 1
Else:
MultiPage1.Value = 0
End If

End Sub
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

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