Determine if clipboard is empty
Just another option to test if the Clipboard is only holding an address
reference
Function LinkingModeQ() As Boolean
With Application
LinkingModeQ = .CutCopyMode = xlCopy Or .CutCopyMode = xlCut
End With
End Function
Sub Demo()
Range("A1").Copy
MsgBox LinkingModeQ
'// Windows: Linking mode compromised, therefore turned off
Application.CutCopyMode = False
MsgBox LinkingModeQ
End Sub
--
HTH
Dana DeLouis
"XP" wrote in message
...
Using Office 2003 and Windows XP;
Is it possible using VBA to determine if there are any contents in the
clipboard?
If so, could someone please post a generic example of how to do this?
Thanks much in advance.
|