To have a picture show up based on VLOOKUP 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 and the
pictures must be stored on the same worksheet as the VLOOKUP formula.

Or you need multiple pictures shown from VLOOKUPS.............

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

Allows for more than one picture to be displayed on a sheet but also
requires the pictures be stored on same sheet.

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

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP

On Thu, 7 May 2009 07:02:01 -0700, willemeulen
wrote:

I was wondering if it would be possible to make a popup window from a range
of small immages depending on which code is inserted in cell. When inserting
a shape code in let say column B (number between 1 - 99) it corresponds with
a certain shape and immage. The image show a small explainatory drawing of
the shape in question, it shows the corresponding lengths for A, B, C. These
lenghts are user difined and will be used in a formula to calculate the total
"cut length" for the shape.

Example

shape code A B C D E

35

After inserting the shape code a little explanitory immage pops up during
inserting of the value's A - E

Or is this to much programming for a simple dude like me

Thanks