How to programmatically code an undo function in Excel-Vba

Question

Is there any way to code an undo function onto a CommandButton similar to Excel's very own undo function?

Answer 1

Add the command button to the worksheet and assign the following macro to it:

Sub UndoLastAction()

    With Application
        .EnableEvents = False
        .Undo
        .EnableEvents = True
    End With

End Sub

I hope this helps you.