DataObject and cliboard

  • Thread starter Thread starter D.2
  • Start date Start date
D

D.2

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.
 
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 :
 
Actually it's a member of msforms library, not from native vba.

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.
Click to expand...

Ok, cool

I added a userform then deleted it just after.
But the reference stay !

Hard to know when you just reed the VBA Help ! this seems to be a
"regular" VBA stuff...
 
Back
Top