XL98: Cannot Paste Picture into UserForm

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you copy a picture, chart, or other graphic object, you cannot paste thepicture into a UserForm in Microsoft Excel 98. The Paste command is unavailable.

CAUSE

This behavior is by design. The only objects you can paste in a UserForm are the UserForm controls.

WORKAROUND

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

Method 1: Inserting a New Dialog Sheet

1. Press and hold Control and 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.

Method 2: Inserting a Picture Using the Image Control

1. Save the picture to a separate graphic file in one of the following formats: Bitmap (.bmp), JPEG (.jpg), GIF (.gif), Metafile (.wmf), Icon (.ico, .cur).



2. If the Control Toolbox toolbar is not visible in your UserForm, point to Toolbars and 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.


NOTE: If you wish to use this method with a chart, you can use the Visual Basic for Applications Export method to create the chart in a GIF file. For more information, please see the following article in the Microsoft Knowledge Base:

Q183131 XL98: How to Create a GIF File from a Microsoft Excel Chart

Additional query words: camera tool snapshot dimmed XL98

Keywords : xldraw
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb