Thread: Throw Exception if Clipboard is Empty
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
  
Posts: 118
Default Throw Exception if Clipboard is Empty
On Oct 19, 7:46*am, PumaMan wrote:
I have a simple paste action in VBA:

* * Range("Q2").Select
* * ActiveSheet.Paste

I'd like to catch and throw an exception if the user's clipboard is empty.. *
Currently, the user gets the "End - Debug" general exception.

I appreciate any help!

How about something like...

If Application.ClipboardFormats(1) = -1 Then
MsgBox "Clipboard Empty!"
End If

....Ron
Reply With QuoteReply With Quote