Clear Clipboard no longer works

[David Henderson]

Please can someone put me right, I have a function to clear the clipboard,
but if I copy it into a new spreadsheet it comes up with an error, "User
Defined Type not Defined"
here is the function
Function ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Function
Why?
Thanks in advance
David

[Dave Peterson]

From Chip Pearson's site:
http://cpearson.com/excel/clipboar.htm

Because these procedures use the DataObject variable type, you must have a
reference set in your VBA project to the Microsoft Forms 2.0 object library.


David Henderson wrote:
>
> Please can someone put me right, I have a function to clear the clipboard,
> but if I copy it into a new spreadsheet it comes up with an error, "User
> Defined Type not Defined"
> here is the function
> Function ClearClipboard()
> Dim MyDataObj As New DataObject
> MyDataObj.SetText ""
> MyDataObj.PutInClipboard
> End Function
> Why?
> Thanks in advance
> David

--

Dave Peterson

[David Henderson]

Thankyou Dave
hope you get this message
David
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> From Chip Pearson's site:
> http://cpearson.com/excel/clipboar.htm
>
> Because these procedures use the DataObject variable type, you must have
> a
> reference set in your VBA project to the Microsoft Forms 2.0 object
> library.
>
>
> David Henderson wrote:
>>
>> Please can someone put me right, I have a function to clear the
>> clipboard,
>> but if I copy it into a new spreadsheet it comes up with an error, "User
>> Defined Type not Defined"
>> here is the function
>> Function ClearClipboard()
>> Dim MyDataObj As New DataObject
>> MyDataObj.SetText ""
>> MyDataObj.PutInClipboard
>> End Function
>> Why?
>> Thanks in advance
>> David
>
> --
>
> Dave Peterson

[Dave Peterson]

Got it.

David Henderson wrote:
>
> Thankyou Dave
> hope you get this message
> David
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > From Chip Pearson's site:
> > http://cpearson.com/excel/clipboar.htm
> >
> > Because these procedures use the DataObject variable type, you must have
> > a
> > reference set in your VBA project to the Microsoft Forms 2.0 object
> > library.
> >
> >
> > David Henderson wrote:
> >>
> >> Please can someone put me right, I have a function to clear the
> >> clipboard,
> >> but if I copy it into a new spreadsheet it comes up with an error, "User
> >> Defined Type not Defined"
> >> here is the function
> >> Function ClearClipboard()
> >> Dim MyDataObj As New DataObject
> >> MyDataObj.SetText ""
> >> MyDataObj.PutInClipboard
> >> End Function
> >> Why?
> >> Thanks in advance
> >> David
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson