_Application.OnUndo Method

Sets the text of the Undo and the name of the procedure that’s run if you choose the Undo command (Edit menu) after running the procedure that sets this property.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub OnUndo ( _
    Text As String, _
    Procedure As String _
)
'Usage
Dim instance As _Application
Dim Text As String
Dim Procedure As String

instance.OnUndo(Text, Procedure)
void OnUndo(
    string Text,
    string Procedure
)

Parameters

  • Text
    Type: System.String

    Required String. The text that appears with the Undo command (Edit menu).

  • Procedure
    Type: System.String

    Required String. The name of the procedure that’s run when you choose the Undo command (Edit menu).

Remarks

If a procedure doesn’t use the OnUndo method, the Undo command is disabled.

The procedure must use the OnRepeat and OnUndo methods last, to prevent the repeat and undo procedures from being overwritten by subsequent actions in the procedure.

See Also

Reference

_Application Interface

_Application Members

Microsoft.Office.Interop.Excel Namespace