Building Undo Into an Excel VBA Macro

by

Excel VBA has the Application.OnUndo function to handle this:

Public Sub DoSomething

    ... do stuff here

    Application.OnUndo "Undo something", "UnDoSomething"
End Sub

Public Sub UnDoSomething

    ... reverse the action here

End Sub

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Levenshtein Distance in VBA [closed]
  5. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  6. How do I base64 encode a string efficiently using Excel VBA?
  7. Assign event handlers to controls on user form created dynamically in VBA
  8. Programmatic Access To Visual Basic Project Is Not Trusted
  9. Can I make this macro more efficient or faster?
  10. Conditional Formatting using Excel VBA code
  11. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  12. How to get the background color from a Conditional Formatting in Excel using VBA
  13. Excel vba add code to sheet module programmatically
  14. Best workaround for VBA Transpose array length limit?
  15. How to Lock the data in a cell in excel using vba
  16. How to use Events with Option Button Controls on Userform [duplicate]
  17. How do I use variables to set properties in VBA (Excel)
  18. VBA: Else without If Error
  19. Workbooks.Open Method in VBA
  20. Windows().Activate works on every computer except one
  21. How to highlight a cell using the hex color value within the cell?
  22. Convert RTF (Rich Text Format) code into plain text in Excel
  23. lastrow and excel table.
  24. Open a workbook from VBA and disable Workbook_Open() code?
  25. Creating form programmatically in the module using vba
  26. How to filter listbox values based on a Textbox value
  27. Find and FindNext for Excel VBA
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment