• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using Reference 'Microsoft Forms 2.0 Object Library'

inddon

Member
Hello There,

I am using MS Office 2010 on Windows 10 (64 bit).

In my VBA code, I am using the below variable which is referencing to 'Microsoft Forms 2.0 Object Library'. It has been enabled through Tools - References:

Code:
Dim oClip As New MSForms.DataObject

The code works fine.

I have the below question:
1. When I use this workbook in another Windows machine(s), would it work fine? or do I have to go to each machine where this workbook would be used and enable 'Microsoft Forms 2.0 Object Library' via Tools-References and enable ?

Could you please advise.

Thanks & regards,
Don
 
Hi !

Not a concern on Windows.
References enabled are saved within workbook …

And you do not even need to activate this reference :
- if you use an Userform within the VBA project,
- or if you replace variable declaration with an activeX via CreateObject
 
Back
Top