Thread: OnKey Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jutlaux jutlaux is offline
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?