DeeToo,

Actually it's a member of msforms library, not from native vba.

you can use it without a userform but you'll need a reference
to Microsoft Forms Object Library. The reference is automatically added
to a workbook when you insert a Userform from VBeditor's Insert menu.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


D.2 wrote :

Hello,

I tryed to use those lines:

With New DataObject
.SetText "my text"
.PutInClipboard
End With

It's suppose tu put a text in the clipboard

The point is that vba said "DataObject" is a type not defined

What is needed to make excel accept this DataObject.
The VBA-HELP uses it "as it" without any comment about that.

Please help.
Thank you.