Excel VBA How to detect if something was pasted in a Worksheet

by 
Private Sub Worksheet_Change(ByVal Target As Range)
  Dim UndoList As String

  '~~> Get the undo List to capture the last action performed by user
  UndoList = Application.CommandBars("Standard").Controls("&Undo").List(1)

  '~~> Check if the last action was not a paste nor an autofill
  If Left(UndoList, 5) = "Paste" Then
    'Do stuff
  End If
End Sub

This did the trick. For those who need something similar and know the size of their list @MaciejLos’ answer would also work.

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. VBA code required for Msg Box when two value equal in two cells
  4. Excel VBA deleting rows in a for loop misses rows
  5. What is the lifetime of a global variable in excel vba?
  6. Download attachment from Outlook and Open in Excel
  7. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  8. Embed picture in outlook mail body excel vba
  9. How to check for empty array in vba macro [duplicate]
  10. Use autofilter on more than 2 criteria
  11. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  12. Load csv file into a VBA array rather than Excel Sheet
  13. Insert line break in wrapped cell via code
  14. Change color of certain characters in a cell
  15. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  16. Making VBA Form TextBox accept Numbers only (including +, – and .)
  17. Inserting an Online Picture to Excel with VBA
  18. Change length of For loop while in the loop
  19. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  20. Consolidating worksheets into one
  21. VBA Macro crashes after 32000 rows
  22. How to create dynamic variable names VBA
  23. How to break a long string into multiple lines
  24. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  25. simple vba code gives me run time error 91 object variable or with block not set
  26. VBA recognizing workbook by partial name
  27. How do I get a list of unique values from a range in Excel VBA?
  28. How to get selected value in multicolumn listbox
  29. Query my excel worksheet with VBA
  30. Delete Hidden/Invisible Rows after Autofilter Excel VBA

Leave a Comment