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?