To control how the Office Clipboard is displayed, click Options at the bottom of the task pane.Īutomatically displays the Office Clipboard when copying items. To clear one item, click the arrow next to the item that you want to delete, and then click Delete.Ĭontrol how the Office clipboard is displayed In the Clipboard task pane, do one of the following: You can delete items from the Office Clipboard individually or all at the same time. To paste all the items that you copied, in the Clipboard task pane, click Paste All. To paste items one at a time, in the Clipboard task pane, double-click each item that you want to paste. You can paste collected items into any Office program. Each entry includes an icon representing the source Office program and a portion of copied text or a thumbnail of a copied graphic.Ĭlick where you want the items to be pasted. The newest entry is always added to the top. If you copy a twenty-fifth item, the first item on the Office Clipboard is deleted.Īs items are added to the Office Clipboard, an entry is displayed in the Clipboard task pane.

The Office Clipboard can hold up to 24 items. Select the first item that you want to copy, and press CTRL+C.Ĭontinue copying items from the same or other files until you have collected all of the items that you want. Open the file that you want to copy items from. Copy and paste multiple items using the Office Clipboard Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.Note: To open the Clipboard task pane in Outlook, in an open message, click the Message tab, and then click the Clipboard dialog box launcher in the Clipboard group. TextBox1.Text = 'Move this data to the ' _

'Need to select text before copying it to Clipboard

Two TextBox controls named TextBox1 and TextBox2.

To use this example, copy this sample code to the Declarations portion of a form.

The Copy and GetText methods are also used. The GetFromClipboard method transfers the data from the Clipboard to a DataObject. The following example demonstrates data movement from a TextBox to the Clipboard, from the Clipboard to a DataObject, and from a DataObject into another TextBox.

Office clipboard excel