Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170449

From BetaArchive Wiki

Article ID: 170449

Article Last Modified on 8/27/2002



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q170449


SYMPTOMS

When you copy a picture, chart or any other graphic object, you cannot paste the graphic object 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.

  1. If the Control Toolbox toolbar is not visible in your UserForm, point to Toolbars and click Control Toolbox on the View menu.
  2. Click the Image control, and draw a box on the UserForm where you would like the picture to appear.
  3. 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 want to use this method with a chart, you can use the Export method in Visual Basic for Applications to create the chart in a GIF file. For more information, please see the following article in the Microsoft Knowledge Base:

163103 How to Create a GIF File from a Microsoft Excel Chart


REFERENCES

For more information about inserting controls in UserForms, from the Visual Basic Editor, click Contents and Index on the Help menu, click the Index tab in Visual Basic Help, type the following text

toolbox


and then double-click the selected text to go to the "Toolbox" topic. If you are unable to find the information you need, ask the Office Assistant.



Additional query words: camera tool snapshot dimmed XL97

Keywords: kbprb KB170449