JE's routine assumes that the pictures are already on the worksheet.

So load your pictures manually (or anyway you know), then use JE's code to
hide/show the ones you want.

Iriemon wrote:

I can't figure out how to insert the pictures? HELP. I can modify the
PicTable on sheet 2 to expand the name range but I haven't been successful in
loading the pictures.

"Dave Peterson" wrote:

Maybe you could do something like JE McGimpsey does at:
http://www.mcgimpsey.com/excel/lookuppics.html

PACF wrote:

Can I include a picture in a formula i.e. if cell a26 90% then show picture
x, if less then show picture y?...

--

Dave Peterson


--

Dave Peterson