+ Reply to Thread
Results 1 to 5 of 5

Take user to different page in MultiPage userform

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Take user to different page in MultiPage userform

    I've got a Multipage userform comprised of several pages.
    On the first page (MultiPage1.pagStart), when clicking a 'start' button, I want to make the next page visible and then take the user to that next page (MultiPage1.pagSetup) and have that next page selected in the page tab strip

    I seem to be able to get the user to see the contents of the next page, but the page selected along the top of the MultiPage tab strip is still the first one

    My code is:
    Please Login or Register  to view this content.
    Any ideas on how I can fix this?

    many thanks!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Take user to different page in MultiPage userform

    Hello EMAP,

    Welcome to the Forum!

    This will advance you to the next page until you reach the last one. It will then take you back one page until you reach the first and starts advancing again. I don't see a reason to hide the pages as the active page is the only one that is shown.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Take user to different page in MultiPage userform

    Hi Leith,

    Thanks for this, but it doesn't seem to work

    The form has several pages in the multipage - pagStart and pagSetup are the first two. The user enters the form on pagStart and the pagSetup is initially set to hidden as I do not want people to be able to see this page in the page tabs until they have selected the btnStartNew button on pagStart (hence the 'MultiPage1.pagSetup.Visible = True' line)

    While the user is shown the content of the second multipage (pagSetup) and the page tab of pagSetup now becomes visible in the page menu tabs once btnStartNew on the first page (pagStart) has been clicked, the page tab at the top of the MultiPage that is selected is still the pagStart tab, and not the pagSetup tab. This means that while the user is actually on the pagSetup page and can see its content, they are given the impression that they have not yet left the pagStart page

    Hope this explains things better.

    Thanks!

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Take user to different page in MultiPage userform

    Hello EMAP ,

    To identify the problem accurately and quickly, you should post your workbook.

  5. #5
    Registered User
    Join Date
    08-30-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Take user to different page in MultiPage userform

    Thanks Leith,

    Rather than go through the full code (many pages of it), I decided to implement the following quick fix instead:

    Please Login or Register  to view this content.
    This effectively hides the initial page before loading the new page, then takes the user to the new page and eventually making the inital page visible again.
    As a result, the correct tab is now highlighted

    Thanks,

    Ben

    [solved]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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