View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob[_62_] Bob[_62_] is offline
external usenet poster
 
Posts: 5
Default Enter key movement direction


"Lowkey" wrote in message
...
Is there any way to set the direction for the Enter key so that it moves
to
the cell on the right instead of the cell below it?

I have a serious amount of data entry that is across the sheet, not down,
and the staff are so used to using the enter key when fingering instead of
the tab key that it's mucking up my data.


Try this:

This example causes the active cell to move to the right when the user
presses ENTER.

Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlToRight
Bob