ExcelBanter - View Single Post

dlanier

"Ron Coderre" wrote:

The VBA solution provided by JE McGimpsey is the generally accepted BEST
approach:
http://www.mcgimpsey.com/excel/lookuppics.html

This is just an alternative if you don't want to use VBA:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(ToolsOptionsView tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. InsertPicture from file. (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
InsertNameDefine
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
InsertNameDefine
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With the picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"DanielWalters6" wrote:

Is it possible to look up the value in a cell, and depending on that display
a small graphic from a table elsewhere in the spreadsheet.

At the moment, I have a small "system" which when a user picks a value from
a combo box, it is then put into a cell, then a cell that is located next to
the drop down displays a description of the product. It does this by looking
up the value that's stored in the cell, within a VLOOKUP statement.

Is it possible to do this with photographs - could I include a small
photograph of the product?

TIA For any help
--
Dan Walters