Clear Clipboard no longer works

David Henderson · Mar 3, 2006

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 · Mar 3, 2006

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 · Mar 5, 2006

Thankyou Dave
hope you get this message
David

Dave Peterson said:
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.

Dave Peterson · Mar 5, 2006

Got it.

David said:
Thankyou Dave
hope you get this message
David

Capturing text in active cell to clipborad (Excel 95)	8	May 3, 2004
Using a custom format on the clipboard	4	Jun 28, 2005
Clear Clipboard in VB	2	Feb 25, 2004
Convert CSV from clipboard into a transposed list (part solution provided)	2	May 23, 2006
Copy outside Clipboard contents (html page) to a cell in Excel	4	Sep 6, 2005
Data type not defined	3	Jul 9, 2009
ActiveSheet.Name?	5	Jul 27, 2003
VBA code not working on other PC	3	Feb 11, 2010

Clear Clipboard no longer works

David Henderson

Dave Peterson

David Henderson

Dave Peterson

Ask a Question

Similar Threads