ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   CLEARING THE CLIPBOARD !!! (https://www.excelbanter.com/excel-programming/429718-clearing-clipboard.html)

Jay Dean

CLEARING THE CLIPBOARD !!!
 

Hi - I am using Chip Pearson's code below to clear the clipboard. I have
assigned it to a form's command control and when I compile, I get "Only
comments may appear after End Sub, End Function, or End property."

What am I doing wrong? Below is how I am using the code:

Private Sub CommandButton2_Click()

Private Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long)
As Long
Private Declare Function EmptyClipboard Lib "user32" () As Long
Private Declare Function CloseClipboard Lib "user32" () As Long

''''Sub ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
''''End Sub

End Sub




*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com