XL97: Cannot Paste Picture into UserForm

 Last reviewed: January 9, 1998
Article ID: Q170449
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When you copy a picture or other graphic object, you cannot paste the picture into a UserForm in Microsoft Excel 97. 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 97. 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 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, .dib), JPEG (.jpg), GIF (.gif), Metafile (.wmf, .emf), Icon (.ico, .cur).

    NOTE: You can save a picture in one of these graphic file formats with Microsoft Photo Editor. This program is a part of Microsoft Office 97. For more information, see the Help file in Microsoft Photo Editor.

2 If the Control Toolbox toolbar is not visible in your UserForm, point to 
   Toolbars and click Control Toolbox on the View menu.

  • Click the Image control, and draw a box on the UserForm where you would like the picture to appear.

  • In the Properties window for the Image control, click the Picture property. In the Load Picture dialog, navigate to your graphic file and click Open. Your picture is displayed in the UserForm.

    REFERENCES

    For more information about inserting controls in UserForms, click the Index tab in Microsoft Visual Basic Help, type "toolbox" (without the quotation marks), and then double-click to view the Toolbox topic.

    • Additional query words: camera tool snapshot dimmed
    Keywords : xldraw xlwin
    Version : Windows:97
    Platform : WINDOWS
    Issue type : kbprb
    Solution Type : kbworkaround

    THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

    Last reviewed: January 9, 1998
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.