Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
keydown event
The Excel Application has an OnKey method (not event procedure) that will run
code when a particular key is pressed: Application.OnKey Key, Procedure Key is the key to look for, Procedure is the name of the procedure you want to run. Special keys such as TAB are designated as {TAB} (there are some exceptions - see help for details). But note: This is an Application setting, so it affects any workbooks you may have open in your Excel session, it overrides any normal Excel processing of the keys, and it stays in effect until it is deactivated (by omitting Procedure from the parameters). You need to be careful how you use it! "bfa" wrote: Hello Im trying to catch a keydown event on a worksheet. If i press on my worksheet any key it should response like an event. How can I make it? I found a lot of examples with controls, but no one on a worksheet. thnx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
KeyDown event on form | Excel Discussion (Misc queries) | |||
user form-on open event? keydown event? | Excel Programming | |||
KeyDown event in sheet | Excel Programming | |||
KeyDown / KeyPress Events | Excel Programming | |||
keydown event | Excel Programming |