| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
keyboard event in user form
Have you set a break point right before you display the form so that you can
walk through the code that is triggered when the user presses enter? It sounds like one of your macros is clearning the form and you just have to find out why. Bob Flanagan Macro Systems Delaware, U.S. 302-234-9857 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "gpjb" wrote in message ... I have a fairly compex userform controlling a hotel reservation system. I have an annoying problem that occurs when the user presses the "enter/return" key - all data on the form disappears. Note: This happens before data is saved. How can I trap the event , not lose the data entered, and continue entering data on to the form? Thanks, gpjb -- gpjb ------------------------------------------------------------------------ gpjb's Profile: http://www.excelforum.com/member.php...o&userid=14081 View this thread: http://www.excelforum.com/showthread...hreadid=382530 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
| EXCEL 2002: How do I user/simulate a Timer event in Excel form | Excel Programming | |||
| EXCEL 2002: How do I user/simulate a Timer event in Excel form | Excel Programming | |||
| user form-on open event? keydown event? | Excel Programming | |||
| How to catch mouse/keyboard event in Office addin | Excel Programming | |||
Threaded Mode
