OnRepeat Method
TOC
Collapse the table of content
Expand the table of content

Application.OnRepeat Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

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.

If a procedure doesn?t use the OnRepeat method, the Repeat command repeats 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.

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"
Show:
© 2016 Microsoft