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

--
Message posted from http://www.ExcelForum.com

Hi
not possible with formulas

--
Regards
Frank Kabel
Frankfurt, Germany


> 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
>
>
> ---
> Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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

"TommyRevs <" wrote:
>
> Thanks, I had thought as much, but I couldn't be sure. Do you know if
> it can be done using macros at all? I'm not too hot with them, I can do
> a bit, so if it is possible, a pointer in the right direction would be
> very useful!!
>
> Thanks again,
> Tom
>
> ---
> Message posted from http://www.ExcelForum.com/

--

Dave Peterson
(E-Mail Removed)