Microsoft KB Archive/211756

= XL2000: Cannot Paste a Picture into a UserForm =

Article ID: 211756

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211756





SYMPTOMS
When you copy a picture or other graphic object, you cannot paste the picture into a UserForm in Microsoft Excel 2000. The Paste command is unavailable.



CAUSE
The only objects you can paste into a UserForm are the UserForm controls.



WORKAROUND
To work around this behavior, use either of the following methods.

Method 1: Insert a New Dialog Sheet
Although you cannot paste a picture into a UserForm, you can paste the picture into a dialog sheet in Excel 2000. To insert a new dialog sheet, follow these steps:
 * 1) Right-click any sheet tab in the workbook. On the shortcut menu, click Insert.
 * 2) In the Insert dialog box, click the General tab, click MS Excel 5.0 Dialog, and then click OK.

NOTE: Dialog sheets do not support as wide a range of functionality as do UserForms.

Method 2: Insert a Picture Using the Image Control
To insert a picture into a UserForm using the Image control, follow these steps:
 * 1) Save the picture to a separate graphic file in one of the following formats: Bitmap (.bmp, .dib), JPEG (.jpg), GIF (.gif), Metafile (.wmf, .emf), or Icon (.ico, .cur).
 * 2) If the Control Toolbox toolbar is not visible in your UserForm, point to Toolbars and then click Control Toolbox on the View menu.
 * 3) Click the Image control, and draw a box on the UserForm where you would like the picture to appear.
 * 4) In the Properties window for the Image control, click the Picture property. In the Load Picture dialog box, navigate to your graphic file and click Open.

Your picture is displayed in the UserForm.

