OnUndo Method [Excel 2007 Developer Reference]

Switch View :
Classic
Lightweight
ScriptFree
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.

Syntax

expression.OnUndo(Text, Procedure)

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
TextRequiredStringThe text that appears with the Undo command (Edit menu).
ProcedureRequiredStringThe 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.

Example

This example sets the repeat and undo procedures.

Visual Basic for Applications
Application.OnRepeat "Repeat VB Procedure", _
    "Book1.xls!My_Repeat_Sub"
Application.OnUndo "Undo VB Procedure", _
    "Book1.xls!My_Undo_Sub"

See Also