how do I add vba reference to Microsoft Forms 2.0 Object Library?

[wrssbrown]

I'm trying to use 'Dim myobj As New DataObject' in VBA to access clipboard,
but VBA won't recognize 'DataObject', which is available in MicroSoft Forms
2.0 object library. can't find MS Forms 2.0 object library in
tools/reference list.

 

[Bob Phillips]

You need to have a reference to the Microsoft Forms library.



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jim Rech]

Try using the Browse button to select c:\windows\system32\FM20.DLL

 

[Jim Cone]

Try adding a form to your project, then look again for the reference.
If still no luck then try browsing to...
C:\ Windows \ System32 \ FM20.dll
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"wrssbrown"
wrote in message
I'm trying to use 'Dim myobj As New DataObject' in VBA to access clipboard,
but VBA won't recognize 'DataObject', which is available in MicroSoft Forms
2.0 object library. can't find MS Forms 2.0 object library in
tools/reference list.

 

[Dave Peterson]

For me, it appears near the top of the list.

But a quick way to create a reference to that library is to add a userform to
your workbook's project.

You can delete it later if you don't need it.

 

[wrssbrown]

thanks for your help. just the right answer, appreciate you took time to
answer.