OnUndo Method

Applies To

Application Object.

Description

Sets the Undo menu item and the name of the procedure that will run if you choose Undo from the Edit menu after running the procedure that sets this property.

Syntax

object.OnUndo(text, procedure)

object

Required. The Application object.

text

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

procedure

Required. Specifies the name of the procedure that runs when you choose Undo from the Edit menu.

Remarks

If a procedure does not use the OnUndo method, the Undo command is disabled.

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

See Also

OnRepeat Method, Repeat Method.

Example

This example sets the repeat and undo procedures.

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