_Application.OnRepeat Method
Sets the Repeat menu item and the name of the procedure that will run if you choose the Repeat command (Edit menu) after running the procedure that sets this property.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub OnRepeat ( _
Text As String, _
Procedure As String _
)
'Usage
Dim instance As _Application
Dim Text As String
Dim Procedure As String
instance.OnRepeat(Text, Procedure)
void OnRepeat(
string Text,
string Procedure
)
Parameters
Text
Type: System.StringRequired String. The text that appears with the Repeat command (Edit menu).
Procedure
Type: System.StringRequired String. The name of the procedure that will be run when you choose the Repeat command (Edit menu).
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.