I want to assign certain pictures that become visible according to the cell
value,
example:
if cell value equals to "Apple", then "Picture 01" becomes visible, if cell
value equals to "Banana", then "picture 02" becomes visible, etc.
also if cell value does not equal to "Apple" nor "Banana", then both
pictures should be invisible.

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

or

http://www.jkp-ads.com/articles/showpicture00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Abdul" wrote in message
...
I want to assign certain pictures that become visible according to the cell
value,
example:
if cell value equals to "Apple", then "Picture 01" becomes visible, if
cell
value equals to "Banana", then "picture 02" becomes visible, etc.
also if cell value does not equal to "Apple" nor "Banana", then both
pictures should be invisible.

Thank you "Niek Otten", your example solved my problem.

I used the example from this link:
http://www.jkp-ads.com/articles/showpicture00.htm

because I didn't have the version of excel after 2003, and I noticed that
using multiple dynamic pictures causes the PC to lag alot, I used 36
instances of this and makes me wait a certain delay between each edit in any
of the cells while they're visible.

I wonder if using the one that requires VB would make it any faster.
by the way I tried several PCs with varying processor powers and I noticed
that almost same delay no matter how the processor is powerful.