Shaun Wingrin
asked on
Excel - copy string to clipboard
Say, I don't want to copy from a cel - but rather the text in a string - its a password that needs to be put in the clipboard. I'm using a macro/VBA code.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I don't see the reference listed for:
'Microsoft Forms 2.0 Object Library"
Using Excel 2013
'Microsoft Forms 2.0 Object Library"
Using Excel 2013
ASKER
say I found it by searching for file mf20.dll
However the code doesn't work...
mankowitz
However the code doesn't work...
mankowitz
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
seems I needed to change to clipboard1 as clipboard was reserved??
I also dimmed the text as a string but doubt this is needed.
I also dimmed the text as a string but doubt this is needed.
Dim clipboard As MSForms.DataObject
Set clipboard = New MSForms.DataObject
clipboard.SetText "PASSWORD"
clipboard.PutInClipboard