Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KeyDown event on form Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 0 October 26th 07 03:30 PM
user form-on open event? keydown event? FSt1[_3_] Excel Programming 2 August 5th 04 02:26 PM
KeyDown event in sheet Peter Wallin Excel Programming 1 February 27th 04 10:25 AM
KeyDown / KeyPress Events Barry Pettis[_2_] Excel Programming 1 February 12th 04 05:09 AM
keydown event jim c. Excel Programming 1 October 10th 03 03:16 AM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"