Specifies the direction in which an active cell moves on an ENTER key press.
A MoveActiveCellModeOnEnterPress enumeration value.
You can access this nested property as listed below:
|Object Type||Path to MoveActiveCellMode|
By default, when the ENTER key is pressed, the SpreadsheetControl moves an active cell one cell down. Use the MoveActiveCellMode property to set another direction to move an active cell (for example, Up, Right or Left). To keep an active cell on an ENTER press, set the MoveActiveCellMode property to the MoveActiveCellModeOnEnterPress.None value.
The SHIFT+ENTER key combination moves an active cell in the opposite direction of what the MoveActiveCellMode property specifies.
TAB and SHIFT+TAB moves an active cell one cell to the right and to the left respectively, and this behavior is not customized.
If a cell range or multiple ranges are selected in a worksheet, ENTER, SHIFT+ENTER, TAB and SHIFT+TAB move an active cell within this selection only.