Export (0) Print
Expand All

StartEdit Method

Office 2003

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 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.

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.



Applies to | PivotTable Object



Show:
© 2014 Microsoft