How do I assign pictures to be visible according to cell value?

A

Abdul

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.
 
A

Abdul

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.
 

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

Top