none
PutInClipBoard error RRS feed

  • Question

  • Hi all, been trying to find out a solution to this issue for a long while now. I have a simple macro to copy data to the clip board but when I use it in Windows8 it pastes two tiny images ("?" in a box). this is really a huge problem for me, and help would be greatly appreciated.

    Dim objMCB As New DataObject, strCopy As String
               
        strCopy = Me.Label1.Value
     
        With objMCB
            .SetText strCopy
            .PutInClipboard
        End With


    Microsoft forms 2.0 object library has always been selected
    • Edited by UKYank66 Monday, September 9, 2013 4:51 PM
    Monday, September 9, 2013 4:31 PM

All replies


  • A Label Control does not have a Value property.
    Try using the Caption property...

    strCopy = Me.Label1.Caption

    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Edited by James Cone Tuesday, October 25, 2016 1:25 AM
    Monday, September 9, 2013 6:18 PM