Choosing pictures

[Guest]

I am making a product feature sheet. Rather than making 50 different one's
for each product, I want to have a single worksheet that drags data and
pictures from a database within the same workbook.

The text is no problem, but I am having trouble with the pictures.

I have ~50 different pictures. Depending upon a choice from a list box, I
want a particular picture to show, and the others to be hidden. No matter
which picture is selected, the picture will appear in the same position.

I also want to store the pictures in the same Excel 2003 file so that I can
distribute the file, with the pictures, to others.

I can't work any standard functions to achieve the desired result and was
thinking VB might be the only way. Anyone got some sample code that might do
the trick?

 

[Norman Jones]

Hi Arnold,

See the techniques used by JE McGimpsey at:

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