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
        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 (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