Add an image control to a worksheet

You use an image control to embed a picture, such as a bitmap (bitmap: A picture made from a series of small dots, much like a piece of graph paper with certain squares filled in to form shapes and lines. When stored as files, bitmaps usually have the extension .bmp.), JPEG (JPEG: A graphics file format (.jpg extension in Microsoft Windows) supported by many Web browsers that was developed for compressing and storing photographic images. It's best used for graphics with many colors, such as scanned photos.), or GIF (GIF: A graphics file format (.gif extension in Windows) used to display indexed-color graphics on the World Wide Web. It supports up to 256 colors and uses lossless compression, meaning that no image data is lost when the file is compressed.) and, for example, to display a company logo or clip art.

  1. If the Developer tab is not available, display it.

ShowDisplay the Developer tab

  1. Click the File tab, click Options, and then click Customize Ribbon.
  2. Under Main Tabs, select the Developer check box, and then click OK.
  1. On the Developer tab, in the Controls group, click Insert, and then under ActiveX Controls, click Image Button image.

Controls group

  1. Click the worksheet location where you want the upper-left corner of the image control to appear.
  2. To edit the ActiveX control, make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image.
  3. To specify the control properties, on the Developer tab, in the Controls group, click Properties Edit code button.

 Tip   You can also right-click the control, and then click Properties.

The Properties dialog box appears. To add an image, click the Build button Button image next to the Image property box, and then browse to an image file in the Load Picture dialog box.

For detailed information about each property, select the property, and then press F1 to display a Visual Basic Help (Visual Basic Help: To get Help for Visual Basic, point to Macro on the Tools menu, and then click Visual Basic Editor. On the Help menu, click Microsoft Visual Basic Help.) topic. You can also type the property name in the Visual Basic Help Search box. The following section summarizes the properties that are available.

Summary of properties by functional categories

If you want to specify Use this property
General:  
Whether the control is loaded when the workbook is opened. (Ignored for ActiveX controls.) AutoLoad (Excel)
Whether the control can receive the focus and respond to user-generated events. Enabled (Form)
Whether the control can be edited. Locked (Form)
The name of the control. Name (Form)
The way the control is attached to the cells below it (free floating, move but do not size, or move and size). Placement (Excel)
Whether the control can be printed. PrintObject (Excel)
Whether the control is visible or hidden. Visible (Form)
Size and Position:  
Whether the size of the control automatically adjusts to display all contents. AutoSize (Form)
The height or width in points. Height, Width (Form)
The distance between the control and the left or top edge of the worksheet. Left, Top (Form)
Formatting:  
The background color. BackColor (Form)
The background style (transparent or opaque). BackStyle (Form)
The color of the border. BorderColor (Form)
The type of border (none or single-line). BorderStyle (Form)
Whether the control has a shadow. Shadow (Excel)
The visual appearance of the border (flat, raised, sunken, etched, or bump). SpecialEffect (Form)
Image:  
The bitmap to display in the control. Picture (Form)
The location of a background picture (top left, top right, center, and so on). PictureAlignment (Form)
How to display the background picture on the control (crop, stretch, or zoom). PictureSizeMode (Form)
Whether you want to tile multiple copies of the picture in the control. PictureTiling (Form)
Keyboard and Mouse:  
A custom mouse icon. MouseIcon (Form)
The type of pointer that is displayed when the user positions the mouse over a particular object (for example, standard, arrow, I-beam). MousePointer (Form)
 
 
Applies to:
Excel 2010