| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if clipboard is empty before pasting
I want my macro button to paste what is in the clipboard onto my excel
document, but if the clipboard is empty I want a message to pop up that states "Your clipboard is empty - retry copying your data." and end the macro. If there is something in the clipboard it should proceed with pasting it. I've tried several things but non of them are working. Cells.Select ActiveSheet.Paste |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if clipboard is empty before pasting
On Feb 3, 12:28*pm, Munchkin
wrote: I want my macro button to paste what is in the clipboard onto my excel document, but if the clipboard is empty I want a message to pop up that states "Your clipboard is empty - retry copying your data." and end the macro. If there is something in the clipboard it should proceed with pasting it. * I've tried several things but non of them are working. * * Cells.Select * * ActiveSheet.Paste Try something like the following...Ron ' test to see if the clipboard is empty If Application.ClipboardFormats(1) = -1 Then MsgBox "Your clipboard is empty - retry copying your data." End Else Cells.Select ActiveSheet.Paste End If |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
| Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
| Pasting clipboard to Excel sheet | Excel Programming | |||
| Check if clipboard is empty before .PasteSpecial xlPasteValues | Excel Programming | |||
| Macro - Pasting clipboard in a find box | Excel Programming | |||
Hybrid Mode
