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?
|