harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
I have a few text boxes (4). The contents of those text boxes get copied over to a 5th text box. Then I have a CommandButton that when clicked will copy the contents (to the clipboard), but when I try to paste it to another program all I get is "??". From another thread I learned that it's because I'm copying unicode characters. Here's what I have:
VBA Code:
Private Sub CommandButton2_Click()
Dim dataObj As MSForms.DataObject
Set dataObj = New MSForms.DataObject
With dataObj
.SetText TextBox5.Value
.PutInClipboard
End With