Enter key movement direction

[Guest]

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.

 

[Bob]

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

 

[Dave Peterson]

Tools|Options|Edit tab|
Change the Move Selection after Enter
to do what you want.

 

[Guest]

Super!

Tools|Options|Edit tab|
Change the Move Selection after Enter
to do what you want.