Application.OnUndo method (Excel)
Sets the text of the Undo command and the name of the procedure that's run if you choose the Undo command after running the procedure that sets this property.
expression.OnUndo (Text, Procedure)
expression A variable that represents an Application object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Text | Required | String | The text that appears with the Undo command. |
| Procedure | Required | String | The name of the procedure that's run when you choose the Undo command. |
If a procedure doesn't use the OnUndo method, the Undo command is disabled.
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.
VB
Application.OnRepeat "Repeat VB Procedure", _
"Book1.xls!My_Repeat_Sub"
Application.OnUndo "Undo VB Procedure", _
"Book1.xls!My_Undo_Sub"
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.