Application.OnRepeat method (Excel)

Artikel
09/13/2021

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

Syntax

expression.OnRepeat (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 Repeat command.
Procedure	Required	String	The name of the procedure that will be run when you choose the Repeat command.

Remarks

If a procedure doesn't use the OnRepeat method, the Repeat command repeats the procedure that was run most recently.

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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Delen via