+ Reply to Thread
Results 1 to 3 of 3

Userform MultiPage - Exit on Escape for second Page

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    518

    Userform MultiPage - Exit on Escape for second Page

    If there is a command button on a form, and the Cancel property is set to True, together with the code below, then the userform unloads when Escape is pressed.
    For a command button on the second page of a MultiPage control, this doesn't seem to to work.
    Is there a way to fix?


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,574

    Re: Userform MultiPage - Exit on Escape for second Page

    You can only have one button on a form that works like that.

    If you do want to change use the button on the second tab you could try changing it's Cancel property when that tab is selected, of course you would also need to change the same property for the button on the first tab.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    518

    Re: Userform MultiPage - Exit on Escape for second Page

    OK thanks for the suggestion. The code below seems to work (partial detail).

    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. [SOLVED] Combo Box - exit on Escape
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2020, 03:26 AM
  2. [SOLVED] Userform multipage control - exit event not firing or event order
    By jane serky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2013, 10:23 AM
  3. [SOLVED] Userform multipage control exit events code execution not completed before next user entry
    By jane serky in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2013, 04:39 AM
  4. Take user to different page in MultiPage userform
    By EMAP in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2012, 08:24 AM
  5. Is it possible to disable a tab/page on a multipage Userform?
    By Trefor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2006, 12:30 PM
  6. [SOLVED] can you set a default page in a Multipage userform?
    By Trefor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2006, 03:30 AM
  7. How to print a page of a multipage userform
    By Jean-Pierre D via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2005, 01:05 PM

Tags for this Thread

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