On Error Resume Next not working

I have the following snippet of my code where the On Error Resume Next is not working if the user inadvertently copies an image into the clipboard.

I just get the error message: Run-time error '-2147221404 (80040064)': DataObject:GetText Invalid FORMATETC structure

I just need to be able to skip the error but can't seem to find an answer if anyone can help please.

Dim dataObj As MSForms.DataObject
Dim strPaste As string

Set dataObj = New MSForms.DataObject
dataObj.GetFromClipboard

On Error Resume Next
strPaste = dataObj.GetText

is that the only "On Error" statement?

I tried it on my end with just the code you posted, and I only get the error message if I comment out the On Error Resume Next statement. When I leave it in, it just continues without errors.

Why not test to see if they've copied text to the clipboard?

Please Login or Register  to view this content.