How to check if there are any copied contents in the clipboard?

[inddon]

Hello There,

I would like to know how to check if the user has copied any contents (row, columns, cells) in the clipboard for the current worksheet in sub 'Worksheet_SelectionChange'.

For eg.
If any copied contents then
'do nothing
else
'do something
end if

Your help is appreciated.

Thanks & regards,
Don

 

[inddon]

Herewith the below code to check if any copied contents exists in Clipboard

If Application.ClipboardFormats(1) = -1 Then