Applies To
Application Object.
Description
Returns the formats currently on the Clipboard, as an array of numeric values. To determine if a particular format is present, compare each element in the array with the appropriate constant shown in the table below. Read-only.
Remarks
This property is available in Microsoft Windows and on the Apple Macintosh. Some formats may be available only on the Apple Macintosh, or only in Microsoft Windows.
This property returns an array of numeric values. To determine if a particular clipboard format is present, compare each element of the array to one of the constants below.
xlClipboardFormatBIFF xlClipboardFormatBIFF2 xlClipboardFormatBIFF3 xlClipboardFormatBIFF4 xlClipboardFormatBinary xlClipboardFormatBitmap xlClipboardFormatCGM xlClipboardFormatCSV xlClipboardFormatDIF xlClipboardFormatDspText xlClipboardFormatEmbeddedObject xlClipboardFormatEmbedSource xlClipboardFormatLink xlClipboardFormatLinkSource xlClipboardFormatLinkSourceDesc xlClipboardFormatMovie xlClipboardFormatNative |
xlClipboardFormatObjectDesc xlClipboardFormatObjectLink xlClipboardFormatOwnerLink xlClipboardFormatPICT xlClipboardFormatPrintPICT xlClipboardFormatRTF xlClipboardFormatScreenPICT xlClipboardFormatStandardFont xlClipboardFormatStandardScale xlClipboardFormatSYLK xlClipboardFormatTable xlClipboardFormatText xlClipboardFormatToolFace xlClipboardFormatToolFacePICT xlClipboardFormatVALU xlClipboardFormatWK1 |
Example
This example displays a message box if the Clipboard contains a rich-text format (RTF) object. You can create an RTF object by copying text from a Word document.
aFmts = Application.ClipboardFormats For Each fmt In aFmts If fmt = xlClipboardFormatRTF Then MsgBox "Clipboard contains rich text" End If Next