Displaying Images as a result of an if statement

[TommyRevs]

Is it possible to write an if statement to display a picture if a cell contains a certain value? Ive got if statements nailed, its not a problem with that i have, just the returning of an image, rather than text ar a hyperlink.

Eg, "if cell A1="stadium", to show a picture of a stadium in cell C1"

Thanks in advance for any help

 

[vconfused]

The only thing I can thing of is to use VBA on the change event to make the object visible = true or false.

 

[Boxus]

Do you want the actual picture in the cell, or just a hyperlink to it?

if you're ok with just a hyperlink, try the following code in cell C1:

=IF(A1="stadium",HYPERLINK("C:\stadium.jpg"),)

Where "C:\stadium.jpg is the file location that you are pointing to.

 

[TommyRevs]

Sorry, if i didn't make myself clear, i'm fine at getting a hyperlink, but i would like the picture just to appear in its designated place.

Thanks for your help anyway.

 

[PaddyD]

neat non-vba approach:

http://www.andypope.info/fun/picviewer.htm

 

[jdee]

PaddyD. I tried the link you suggested and the download and was unable to get the files. Message reads after download "no files to extract". Is anyone else having this problem? Thank you for the link though, has lots of neat information on the page. J.Dee

 

[PaddyD]

works fine for me...I've sent the file to you email.

 

[jdee]

PaddyD:
Thank you for the email you sent with the file. Tried it this a.m. and now works fine. I appreciate the fact you took your time to send it to me. J.Dee

 

[vconfused]

I had the same problem, but a few minutes later it worked fine. This is really neat!

 

[conradg]

The example is not helping. The statement is
If A1=desk then display pic of desk

Can anyone help with this?

Thank you
Gregg