title: Check content of clipboard before pasting
body: <p>Is it possible to check content of clipboard before pasting it in Excel VBA</p>
  
  <p>I have this today:</p>
  
  <pre><code>Sheets.Add After:=Sheets(Sheets.Count)   ' Create new sheet
  ActiveSheet.Paste                        ' Paste from Clipboard
  IsMultiLevel = (InStr(Range("A1"), "Multi-Level") &gt; 0) ' Determine type of report
  If Not IsMultiLevel Then
      MsgBox ("ERROR in Clipboard Data!!")
      End
  Else
      ActiveSheet.Delete
  End If
  </code></pre>
  
  <p>Bu I whish to check data before adding new sheet, then I dont need to delete it.. I want somthing like this</p>
  
  <pre><code>IsMultiLevel = (InStr([CLIPBOARD], "Multi-Level") &gt; 0) ' Determine type of report
  If Not IsMultiLevel Then
      MsgBox ("ERROR in Clipboard Data!!")
      End
  End If
  Sheets.Add After:=Sheets(Sheets.Count)   ' Create new sheet
  ActiveSheet.Paste                        ' Paste from Clipboard
  </code></pre>