Can't Change Clipboard Due to DataObject Error

[kencushing]

I have some simple code that I found on the web that populates the clipboard with whatever text you specify.

The problem is that VBA for Excel is not recognizing the DataObject data type.

Is there a Reference that I need to add? Or what am I doing wrong?

The sample code is below.



Sub PutInClip(sTags As String)

Dim doObject As DataObject

Set doObject = New DataObject

doObject.SetText sTags
doObject.PutInClipboard

End Sub

 

[Norie]

Add a reference to the MS Forms 2.0 Object Library.

 

[timorrill]

I'm not certain about this, but I think a DataObject is used only in the context of a UserForm, which means that this code would have to appear as part of the UserForm.

 

[timorrill]

My mistake -- please defer to Norie on this one!

A reference to the MS Forms 2.0 Object Library will indeed do the trick.

Norie -- great job!

 

[kencushing]

This worked perfectly.

Thank you so much!