ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change the action of TAB Key (https://www.excelbanter.com/excel-programming/432850-change-action-tab-key.html)

Janie

Change the action of TAB Key
 
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

Change the action of TAB Key
 
Janie wrote:
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[_2_]

Change the action of TAB Key
 
"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" wrote:

Janie wrote:
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.


Phil Hibbs

Change the action of TAB Key
 
"XXX" would be the name of the sub that hitting the key calls

I thought there might be one already.

Phil Hibbs.


All times are GMT +1. The time now is 01:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com