PDA

View Full Version : Solved: multipage page selection?



maryam
05-16-2007, 03:01 AM
I have a multipage on my form. How can I write a code under userform_initialize so that when form initialiaze page 1 of multipage1 will come first?

Aussiebear
05-16-2007, 03:24 AM
Loading User forms with MultiPage To select a page in a Multipage object is fairly simple. Just remember the page 1 has a value of 0, page 2 a value of 1 and so forth. To load a form with a specific page in mind, try using these codes.

Sub page2()
UserForm1.MultiPage1.Value = 1 'this sets page 2
UserForm1.Show 'this displays the user form after page 2 has been set
End Sub

Aussiebear
05-16-2007, 03:37 AM
Maryam, have just remembered that Jimmy constructed some code for me which dealt with a multipage control. If you open the file and view code you will see a number of examples relating to the multipage. One or more of these may be clearer than that which I initially posted.

maryam
05-16-2007, 04:55 AM
Thank you very much for your reply and for sharing those files with me.

christianr
05-29-2017, 07:51 AM
Hi!
Is it possible to get ahold of Jimmy's code as described above?
Best regards
Christian