Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last KeyStroke
Is there a way VBA can tell the last keystroke that a user entered? Here is
what I want to do: If the user hits enter, instead of going down one row, I wish to go across one column. But if they press the arrow keys, then I don't want to "alter" their choice. So if they press the down arrow, they go down one cell, but if they press the enter key they go right one cell. Ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last KeyStroke
On Jul 23, 11:03*am, Mike H. wrote:
Is there a way VBA can tell the last keystroke that a user entered? *Here is what I want to do: If the user hits enter, instead of going down one row, I wish to go across one column. *But if they press the arrow keys, then I don't want to "alter" their choice. * So if they press the down arrow, they go down one cell, but if they press the enter key they go right one cell. *Ideas? Google "OnKey events"... or check out this http://msdn.microsoft.com/en-us/libr...ffice.11).aspx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last KeyStroke
Tools - Options - Edit tab and change Move Selection After Enter to Right.
-- HTH... Jim Thomlinson "Mike H." wrote: Is there a way VBA can tell the last keystroke that a user entered? Here is what I want to do: If the user hits enter, instead of going down one row, I wish to go across one column. But if they press the arrow keys, then I don't want to "alter" their choice. So if they press the down arrow, they go down one cell, but if they press the enter key they go right one cell. Ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing a keystroke | Excel Discussion (Misc queries) | |||
One keystroke per cell | Excel Discussion (Misc queries) | |||
Repetitive keystroke | Excel Discussion (Misc queries) | |||
Shortcut Keystroke for Name Box | Excel Discussion (Misc queries) | |||
Keystroke identification | Excel Programming |