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.
PivotArrowModeEnum
PivotArrowModeEnum can be one of these PivotArrowModeEnum constants. |
plArrowModeAcceptdefault Accept the edit and move to the next cell. |
plArrowModeEdit Move the insertion point left or right one position within the cell. |
PivotCaretPositionEnum
PivotCaretPositionEnum can be one of these PivotCaretPositionEnum constants. |
plCaretPositionAtEnddefault |
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.
Applies to | PivotTable Object
See Also | EndEdit Method | StartEdit Method