Results 1 to 7 of 7

Userform and "ESC" - how to prevent?

Threaded View

hannes001 Userform and "ESC" - how to... 02-02-2009, 10:28 AM
mikerickson Re: Userform and "ESC" - how... 02-02-2009, 10:30 AM
hannes001 Re: Userform and "ESC" - how... 02-02-2009, 11:17 AM
LordMarcus Re: Userform and "ESC" - how... 02-03-2009, 01:34 AM
Leith Ross Re: Userform and "ESC" - how... 02-03-2009, 05:21 AM
hannes001 Re: Userform and "ESC" - how... 02-03-2009, 07:16 AM
LordMarcus Re: Userform and "ESC" - how... 02-03-2009, 08:11 PM
  1. #1
    Registered User
    Join Date
    01-30-2009
    Location
    Estonia
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19

    Userform and "ESC" - how to prevent?

    When user presses "ESC" key on an open userform, data he has changed in controls (simple textbox for example) gets resetted. Right? I'm seeing such behavior in Excel 2003. How about other versions?

    I'd like to see some documentation about what exactly is going on, and how to prevent such unexpected feature (that forces data loss), but could not find.

    I mean that i have no commandbutton with cancel=true. By default I want to keep the data user has entered/changed. Unfortunately this data reset finds place before any trappable event, or am i wrong?

    I have not found any working way to capture keypresses on userform level. Userform has _KeyPress and other events, but those are not firing? If there is one, that would be helpful. Perhaps even on system level with some APIs? Altough that sounds way too complicated for a problem that should need only one little-known flag set. Perhaps there is such property somewhere?




    --
    Please pardon my language, this is my first public writing in english.
    Last edited by hannes001; 02-06-2009 at 12:38 PM. Reason: Got enough hints. Thanks everyone!

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