• Hot Topics

Excel Clearing Clipboard in Excel 2013 VBA

Hello guys., i have found this code and tried it out., upon checking., it seems it is applicable only for 2004 and below excel versions. is there other way to clear the clipboard in excel 2013? Option Explicit Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long Public Declare Function EmptyClipboard Lib "user32" () As Long Public Declare Function CloseClipboard Lib "user32" () As Long Public Function ClearClipboard() OpenClipboard (0&) EmptyClipboard CloseClipboard End Function Sub Test() Call ClearClipboard End Sub regards, melson

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of April 15, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel