+ Reply to Thread
Results 1 to 4 of 4

Open UserForm on specific Multipage

  1. #1
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Open UserForm on specific Multipage

    Hello

    I'm trying to get my UserForm to open on a specific multipage. I have 3 pages and need it to open on the 2nd via my UserForm1_Initialize private sub.

    Is this possible?

    Many thanks

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Open UserForm on specific Multipage

    The routine is called UserForm_Initialize and not UserForm1_Initialize (or it won't run). You just need to set the value of your multipage to 1 (the indexing starts at 0):
    Please Login or Register  to view this content.
    for example.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    04-04-2014
    Location
    Tetbury, England
    MS-Off Ver
    Excel 2010
    Posts
    254

    Re: Open UserForm on specific Multipage

    So simple! Thank you


  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Open UserForm on specific Multipage

    Try this:-
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Open UserForm that contains a MultiPage and Scroll Bar
    By Gal403 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2014, 02:27 AM
  2. [SOLVED] Userform multipage tab to open Sheet2 of workbook
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2013, 08:02 AM
  3. Select specific MultiPage in a UserForm with other pages grayed out
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2012, 02:56 PM
  4. Help Populating Textboxes in Userform, With Multipage Userform.
    By mdmorgan24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2012, 05:29 PM
  5. Userform Multipage Help
    By redjay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-25-2008, 04:41 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1