StartEdit Method
Places the active detail cell into edit mode.
expression.StartEdit(InitialValue, ArrowMode, CaretPosition)
expression Required. An expression that returns one of the a PivotTable object.
InitialValue Optional Variant. Specifies the initial value to use when editing the cell. The current value is used if you do not specify a value for this argument.
ArrowMode Optional PivotArrowModeEnum. Specifies how the left and right arrows function while the user is in edit mode.
| PivotArrowModeEnum can be one of these PivotArrowModeEnum constants. |
| plArrowModeAccept default Accept the edit and move to the next cell. |
| plArrowModeEdit Move the insertion point left or right one position within the cell. |
CaretPosition Optional PivotCaretPositionEnum. Specifies the position of the insertion point within the cell.
| PivotCaretPositionEnum can be one of these PivotCaretPositionEnum constants. |
| plCaretPositionAtEnd default |
| plCaretPositionAtMouse |
Remarks
This method will result in a run-time error if the current selection is not a detail cell, or if the current data is not editable.