Displaying images as a result of an 'if' statement

[TommyRevs]

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

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

Thanks in advance for any hel

 

[Frank Kabel]

Hi
not possible with formulas

 

[TommyRevs]

Thanks, I had thought as much, but I couldn't be sure. Do you know i
it can be done using macros at all? I'm not too hot with them, I can d
a bit, so if it is possible, a pointer in the right direction would b
very useful!!

Thanks again,
To

 

[Dave Peterson]

Maybe J.E. McGimpsey's code will help you get started:

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm