Using Clipboard via vba (Excel)?
Set a reference to the MSForms library (which is there automatically if you
have a user form in the project), and use the DataObject object.
Dim DataObj As DataObject
Set DataObj = New DataObject
DataObj.SetText "this is a string"
DataObj.PutInClipboard
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
Quote:
> Dear all,
> How can I use the object Cliboard in a VBA project (under excel) ?
> Using commands like temporary pasting in cells via activecell.pastespecial
> ... is not a solution ?
> I really need to use the object in the same way as in VB.
> Can someone help me ?
> Thanks
> Vblover
