MoveAfterReturnDirection Property Example
This example causes the cell to the right of the active cell to be selected after the user presses the ENTER key.
Set c = Spreadsheet1.Constants
Spreadsheet1.MoveAfterReturn = True
Spreadsheet1.MoveAfterReturnDirection = c.ssToRight