#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default OnKey Help

I want to assign a macro to the specific key strokes CTRL+down arrow and
have used the following syntax:

Sub Verification()
Application.OnKey "^{DOWN}", "MyShortcut"
End Sub

This works when the keys are pressed in the order CTRL then down arrow, but
if I hit the down arrow first then CTRL nothing happens. In most cases with
the "OnKey" the key order does not matter, but for some reason in this case
it does. How can I make it so the order of the keys in this case doesn't
matter?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 718
Default OnKey Help

This is a general behaviour of Windows:
Ctrl (like Shift or Alt) must be pressed BEFORE any othe key.

These special keys toggle something in windows, so that subsequent
keypresses are interpreted in a a special context.

If you first press an ordinary key, Windows interprets it as a normal key

HTH
--
AP

"jutlaux" a écrit dans le message de
news: ...
I want to assign a macro to the specific key strokes CTRL+down arrow and
have used the following syntax:

Sub Verification()
Application.OnKey "^{DOWN}", "MyShortcut"
End Sub

This works when the keys are pressed in the order CTRL then down arrow,
but
if I hit the down arrow first then CTRL nothing happens. In most cases
with
the "OnKey" the key order does not matter, but for some reason in this
case
it does. How can I make it so the order of the keys in this case doesn't
matter?



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
OnKey Hernan Excel Programming 2 January 11th 06 04:18 PM
Help with using OnKey keithb Excel Programming 1 December 19th 05 11:03 PM
onkey help wardy Excel Programming 0 July 20th 04 05:49 PM
onkey peter Excel Programming 2 March 2nd 04 07:34 PM
Onkey Jase Excel Programming 1 November 17th 03 11:07 PM


All times are GMT +1. The time now is 04:57 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"