OnRepeat Method

Applies To

Application Object.

Description

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

Syntax

object.OnRepeat(text, procedure)

object

Required. The Application object.

text

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

procedure

Required. Specifies the name of the procedure that will run when you choose Repeat from the Edit menu.

Remarks

If a procedure does not use the OnRepeat method, the Repeat command repeats the most recently run procedure.

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

OnUndo 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"