May 27, 2019

Use UP and DOWN Keys

How to use UO and DOWN keys on keyboard to increase or decrease worksheet cell values using the Application.Onkey method.
rApplication.OnKey method (Excel) Runs a specified procedure or macro when a particular key or key combination is pressed.
Application.OnKey (Key, Procedure): The method requires two parameters – the key to be pressed and the macro or procedure to be run. Key is a required String and it indicates which key is to be pressed. The ‘procedure’ parameter is a string that represents the name of the procedure to be run. If the string is left blank then no action takes place. Watch the video below:

Here’s the complete VBA code to use short-cut keys to run a macro or procedure:

Sub incrementValue()
Range(“B2”).Value = Range(“B2”).Value + 1
End Sub

Sub decrementValue()
Range(“B2”).Value = Range(“B2”).Value – 1
End Sub

Private Sub Workbook_Open()
Application.OnKey “{Up}”, “incrementValue”
Application.OnKey “{Down}”, “decrementValue”
End Sub

Further Reading:
Application.OnKey method (Excel)
Disable key or key combination or run a macro if you use it
2 Ways to Assign Keyboard Shortcuts to Macros