Hi,
I am trying to use the WASD keys to move the current cell up,down,left and right however my application.onkey is not working.
This is what I have in my workbook module and then in a seperate module I have the offset functions. However when I press W a W appears in the cell.
Anyone know what I am doing wrong?
Thanks
I am trying to use the WASD keys to move the current cell up,down,left and right however my application.onkey is not working.
Code:
Public Sub workbook_open(ByVal target As Range)Application.OnKey ("w"), "moveup"
Application.OnKey ("a"), "moveleft"
Application.OnKey ("s"), "moveright"
Application.OnKey ("d"), "movedown"
End Sub
This is what I have in my workbook module and then in a seperate module I have the offset functions. However when I press W a W appears in the cell.
Anyone know what I am doing wrong?
Thanks