Run Macro on Keypress

[GaryStone10]

Hi all

This seems like it should be simple, but my google searching skills might be letting me down.

I want to have some code on a sheet so that whenever a user presses the up or down buttons it runs a macro.

Is this possible, and if so, how?

Many thanks in advance.
Gary Stone.

 

[jbeaucaire]

What about left or right?

There is a Worksheet_SelectionChange event macro that is triggered every time you change cells, so putting your code into that event might do the trick for you?

 

[Andrew Poulsom]

Try:

Sub SetKey()
    Application.OnKey "{UP}", "YourMacro"
End Sub
 
Sub CancelKey()
    Application.OnKey "{UP}"
End Sub

Change YourMacro to the name of your macro and run the SetKey procedure. Run the CancelKey procedure to return to normal behaviour.

 

[GaryStone10]

Try:

Sub SetKey()
    Application.OnKey "{UP}", "YourMacro"
End Sub
 
Sub CancelKey()
    Application.OnKey "{UP}"
End Sub

Change YourMacro to the name of your macro and run the SetKey procedure. Run the CancelKey procedure to return to normal behaviour.

That works fine, many thanks.