Change the action of TAB Key

[Janie]

I know how to control the movement of the ENTER key, but what about the TAB
key? I want to compel the TAB key to always move DOWN. Suggestions?

 

[Phil Hibbs]

I know how to control the movement of the ENTER key, but what about the TAB
key?  I want to compel the TAB key to always move DOWN.  Suggestions?

Application.OnKey "{TAB}", "xxx"

where xxx is whatever moves the cursor down, not sure about that bit.

Phil Hibbs.

 

[Patrick Molloy]

"XXX" would be the name of the sub that hitting the key calls
so

Sub StartKey()
Application.OnKey "{TAB}", "setMovement"
End Sub
Sub setMovement()
Selection.Offset(1).Select
End Sub

 

[Phil Hibbs]

"XXX" would be the name of the sub that hitting the key calls

I thought there might be one already.

Phil Hibbs.