Skip to content

Latest commit

 

History

History
53 lines (33 loc) · 1.47 KB

Excel.Application.OnRepeat.md

File metadata and controls

53 lines (33 loc) · 1.47 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.OnRepeat method (Excel)
vbaxl10.chm133181
vbaxl10.chm133181
Excel.Application.OnRepeat
7d535e14-c779-af87-60eb-68ec8e651459
04/05/2019
medium

Application.OnRepeat method (Excel)

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"

[!includeSupport and feedback]