This blog is a knowledge base...where I clip cool tricks and urls

excel > hook on pressed keys

Ctrl+C , Ctrl+V , Ctrl+ X
Copy, Paste, Paste special
Have you considered using the Application.OnKey method? You can intercept just about any key press possible by using this method. Here is some of the description from Excel help:
Procedure   Optional Variant. A string indicating the name of the procedure to be run. If Procedure is "" (empty text), nothing happens when Key is pressed. This form of OnKey changes the normal result of keystrokes in Microsoft Excel. If Procedure is omitted, Key reverts to its normal result in Microsoft Excel, and any special key assignments made with previous OnKey methods are cleared.
Remarks
The Key argument can specify any single key combined with ALT, CTRL, or SHIFT, or any combination of these keys. Each key is represented by one or more characters, such as "a" for the character a, or "{ENTER}" for the ENTER key.
Runs a specified procedure when a particular key or key combination is pressed.
expression.OnKey(Key, Procedure)
expression   Required. An expression that returns an Application object.
 blog it

3 comments:

Anonymous said...

Amiable dispatch and this fill someone in on helped me alot in my college assignement. Thank you seeking your information.

pay per head service said...

I think you giving great advice for playwrights staring out.Very nicely described your thoughts here.I like to read more about this.

Anonymous said...

top [url=http://www.001casino.com/]free casino games[/url] hinder the latest [url=http://www.realcazinoz.com/]free casino[/url] free no consign bonus at the foremost [url=http://www.baywatchcasino.com/]no lay down gratuity
[/url].