Consulting

Results 1 to 5 of 5

Thread: Solved: multipage page selection?

  1. #1

    Solved: multipage page selection?

    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?

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,058
    Location
    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
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,058
    Location

    Jimmy's Code for multipage

    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.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    Thank you very much for your reply and for sharing those files with me.

  5. #5
    Hi!
    Is it possible to get ahold of Jimmy's code as described above?
    Best regards
    Christian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •