XL2000: Cannot Paste a Picture into a UserForm (211756)

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.