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

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.

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

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)

"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.

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

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

--
Jim
"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.

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

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.

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

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 wrote:

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

how do I add vba reference to Microsoft Forms 2.0 Object Libra
 

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



"Jim Rech" wrote:

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

--
Jim
"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.