| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Event duplicating action | Excel Programming | |||
| Change to a Cell causes action | Excel Programming | |||
| Change in action when converting to *.xla | Excel Programming | |||
| Cell change causes action | Excel Programming | |||
| Evaluate cells for change and then action | Excel Programming | |||
Linear Mode
