ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   keydown event (https://www.excelbanter.com/excel-programming/327621-re-keydown-event.html)

K Dales[_2_]

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



All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com