Use VBA to test if Windows Clipboard is empty?

How can I use VBA to test if the Windows Clipboard is empty? In the past I’ve use the code “Application.CutCopyMode” to test the Excel clipboard status – it returns 1 if the clipboard has contents and it returns 0 if empty. I have a situation that I copy data from Notepad to paste into Excel through an existing VBA application. I’m trying to add an error handling piece should the Windows clipboard it empty what the macro is ran. I discovered that while I can paste from Notebook, “Application.CutCopyMode” still returns a 0. So apparently I need a different way to test the Windows Clipboard than I do the Excel Clipboard. Would appreciate any suggestions. Thanks.

That does the trick - Thanks!

Interesting you mention that bakerman2. I "thought" I had that library loaded, but when I first tried humdingaling's solution it err'd out - when I doubled checked, that library was missing and once added it worked. However, I have a dozen or so userforms in my personal.xlsb file which was open (although hidden) at the time. Do you have to have a userform in the given workbook that you want to use the library?

Is there a way to "accidentally" remove it? I'm pretty sure I had it - seems like I needed it for a different VBA solution in years past. I had to reload my PC at the end of last year, so it's possible that's when I lost it - just would be surprised if it's been missing that long without causing me a problem. I'll watch it now - see it it disappears again. Thanks for the info.