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