+ Reply to Thread
Results 1 to 3 of 3

Userform Multipage cancel tab change on conditions

  1. #1
    Forum Contributor
    Join Date
    07-01-2018
    Location
    Adelaide, South Australia
    MS-Off Ver
    Office 365, & Excel 2016 on windows 10, & 14.7 for mac, & Excel 2015 for mac
    Posts
    173

    Userform Multipage cancel tab change on conditions

    I have a multipage with two tabs, indexs 0 and 1.

    I want to have the user start on page 1, and then only be allowed to access the 0 tab if they have filled in certain conditions.
    If they click on the tab without the correct conditions the tab should not change, and the user will be prompted with a messagebox.

    My code triggers the msgbox correctly but doesn't affect the tab that is shown. Any help would be appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Userform Multipage cancel tab change on conditions

    It’s a long standing bug in the multi page control, changing the page in the exchange event handler doesn’t work properly. The usual was around this is to have a button to press when they’ve finished filling things in that does the valuation - like a next button. You could also hide the tab names and replace them with command buttons

  3. #3
    Forum Contributor
    Join Date
    07-01-2018
    Location
    Adelaide, South Australia
    MS-Off Ver
    Office 365, & Excel 2016 on windows 10, & 14.7 for mac, & Excel 2015 for mac
    Posts
    173

    Re: Userform Multipage cancel tab change on conditions

    I see.

    I think I'll leave the tab format, and simply add validation to later processes.

    Well thanks for letting me know it wasn't something I had wrong.

+ 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. [SOLVED] Excel userform textboxes not updating, after change in MultiPage tab
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 46
    Last Post: 07-16-2018, 03:24 AM
  2. [SOLVED] Set No Focus in Userform Multipage Change Event
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2016, 04:54 PM
  3. Change color for pages in multipage on userform
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2015, 03:27 PM
  4. [SOLVED] Change tab forecolor multipage UserForm
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 06:08 AM
  5. [SOLVED] Change position of Multipage on userform
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2014, 05:43 PM
  6. [SOLVED] New to Forms-How cancel Multipage change page event?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2013, 08:11 PM
  7. Userform Multipage Event Change
    By sepandb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2008, 01:40 PM

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