How do I use formulae to display a specific picture in a cell?

G

Gord Dibben

You will need event code to display an image based upon a value in a cell.

Note that images float on top of cells........not in the cells.

Have a look at these couple of solutions.

Note: in both cases the jpgs must be stored on the same worksheet you are
calling from.

To have a picture show up when you select an item from a DV list or type in a
name see JE MCGimpsey's site.

http://www.mcgimpsey.com/excel/lookuppics.html

As written John's code allows for only one picture to be displayed.

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed based upon a value.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to display a picture 1
Picture displayed when item selected in a different cell 2
Displaying a Picture with a Macro 1
PICTURE TROUBLES 0
How do I substitute text with a picture as a "comment" to a cell 1
How do I scan a picture into a cell in excel? 3
how do i change a picture in a spreadsheet using a macro? 1
How do I copy a picture from Paint to a specific cell in Excel? 1

Top