Hello excel users,

A copy and paste actions invokes a Worksheet_Change event which is fine.

Is it possible to detect that the user performs a copy and paste action?


For example the Worksheet_Change event can look something like this in
pseudocode:

**********
Private Sub Worksheet_Change(ByVal Target As Range)

If User entered data Then
Debug.Print "You entered data in a cell"
ElseIf user performs a copy and paste Then
Debug.Print "You did a copy and paste"
ElseIf User deleted the contents of a cell Then
Debug.Print "You deleted the contents"
End If

end sub
**********

Thanks in advance
Bret