Syntax

expression.OnUndo(Text, Procedure)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Text Required String The text that appears with the Undo command (Edit menu).
Procedure 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 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"
on undo On Undo Method onundo OnUndo Method Set name of procedure to execute on undo command?

See also: