View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carl[_7_] Carl[_7_] is offline
external usenet poster
 
Posts: 4
Default How do I reference "DataObject"?

I'm trying to retrieve text from the windows clipboard in my Excel
2003 application. I've checked Chip Pearson's website and found the
code that does exactly what I need to do. The following line fails
with the error "User-defined type not defined".

Dim ClipboardISBN As dataobject

I read in another thread, "it's a member of msforms library, not from
native vba. you'll need a reference to Microsoft Forms 2.0 Object
Library. The reference is automatically added to a workbook when you
insert a Userform from VBeditor's Insert menu."

I added a userform and tried to compile but no go for me. I must need
to install something else because I could not even see a reference to
Microsoft Forms Object Library in the references window in the VBA
Editor.

How do I reference "dataobject"? What am I doing wrong????

Thank you,

Carl