User-defined type not defined on Copy to Clipboard Macro

So running a simple copy to clipboard macro and I am receiving a Compile error: User-defined type not defined error. This code worked on another spreadsheet where I had it embedded into a userform, so I'm a little confused as to the difference between the two events and why I'm receiving an error on this one.

Reference to the Microsoft Office 14.0 Object Library is active.
Reference to the Microsoft Excel 14.0 Object Library is active.

Please Login or Register  to view this content.

Good afternoon vamosj

Hmmmmm, it's quite a while since I used the DataObject object, but i seem to remember that you need the Microsoft Forms 2.0 Object Library referenced.
Try setting that one up.

HTH

DominicB

Edit : BTW, setting up a userform automatically references the Forms 2.0 library, which is why this worked in your other file without you needing to set the reference.

Add a userform, then delete it.

Or you could try late-binding.

Please Login or Register  to view this content.

Originally Posted by dominicb

BTW, setting up a userform automatically references the Forms 2.0 library, which is why this worked in your other file without you needing to set the reference.

Originally Posted by Norie

Add a userform, then delete it.

This is how one suddenly feels like an idiot.

Thank you Norie and dominicb, I now have access to my DataObject. Didn't have to delete the form, just had to have one. Now to go get more coffee.

Thank you both.