Check the clipboard's Contents? (WD97)

[musical1]

How can I confirm that the clipboard actually has contents? I have a macro that pastes the contents of the clipboard, but if the clipboard is empty, it errors out on Selection.Paste.

SO, I guess I am wanting to "disable" the paste option if there are no contents on the clipboard.

[Hubert_NY]

Can you use an "On Error Resume Next" statement to skip the paste if there's nothing in the clipboard?

[There is a "CanPaste" method to test whether or not you can paste into an object on a form, but I don't know of a related method for the selection object, but maybe somebody else on the Board will.]

[StuartR]

To check that the clipboard has text on it you can use something like...

Dim objTest As New DataObject
objTest.GetFromClipboard
If objTest.GetFormat(1) = True Then
<font color=448800>'Put your code here</font color=448800>
End If

You may need to use Tools > References to add a reference to the Microsoft Forms 2.0 Object Library if the DataObject doesn't seem to exist on your system.

StuartR