VBA Clearing the clipboard.

[dprayner]

Hi I am using the VB Editor in MS Word. I was wondering what the best way to empty the contents of the clipboard.

Thank you, DAVE

 

[Bogiemon]

They maybe a easier way, but this works.

Dim ClipBoard As DataObject
Set ClipBoard = New DataObject
ClipBoard.SetText ""
ClipBoard.PutInClipboard

 

[Nikita6003]

Hiya,

You can use the

DataObject

to write to and read from the Windows clipboard. You'll need to set a reference to MS Forms 2.0 in your project (use Tools > references in the VBA editor), then use code like this:

Public Sub EmptyClipBoard()
    Dim myClipboard As New DataObject
    Dim l_sText As String
    Dim l_sTest As String
    
    l_sText = "Hallo, world"
    
    myClipboard.SetText l_sText
    myClipboard.PutInClipboard
    
    myClipboard.GetFromClipboard
    l_sTest = myClipboard.GetText
    MsgBox l_sTest
    
    myClipboard.Clear
    Set myClipboard = Nothing
    
End Sub

HTH

Cheers
Nikki


Cheers
Nikki
Look, mommy, I'm flying!