Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Clipboard no longer works
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Clipboard no longer works
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Clipboard no longer works
Thankyou Dave
hope you get this message David "Dave Peterson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Clipboard no longer works
Got it.
David Henderson wrote: Thankyou Dave hope you get this message David "Dave Peterson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ALT+ENTER no longer works | Excel Discussion (Misc queries) | |||
ActiveWindow.Width no longer works for me! | Excel Programming | |||
ActiveWindow.Width no longer works for me! | Excel Programming | |||
Macro no longer works in XP | Excel Programming |