Microsoft KB Archive/178735

{|
 * width="100%"|

XL98: Cannot Paste Picture into UserForm

 * }

-

The information in this article applies to:


 * 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
Although you cannot paste a picture in a UserForm, you can paste the picture in a dialog sheet in Microsoft Excel. To insert a new dialog sheet, follow these steps:


 * 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.

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

Method 2: Inserting 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), 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.

Additional query words: camera tool snapshot dimmed XL98

Keywords : xldraw

Version : MACINTOSH:98

Platform : MACINTOSH

Issue type : kbprb

Technology :