PC Review


Reply
Thread Tools Rate Thread

Displaying images as a result of an 'if' statement

 
 
TommyRevs
Guest
Posts: n/a
 
      2nd Sep 2004
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

 
Reply With Quote
 
 
 
 
Frank Kabel
Guest
Posts: n/a
 
      2nd Sep 2004
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/


 
Reply With Quote
 
TommyRevs
Guest
Posts: n/a
 
      3rd Sep 2004
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

 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      3rd Sep 2004
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)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
displaying formula result Utkarsh Microsoft Excel Programming 1 15th Jan 2010 06:26 PM
Fomula result not displaying stagiana@gmail.com Microsoft Excel Worksheet Functions 2 22nd May 2007 05:48 PM
Block images security feature / Images not displaying correctly =?Utf-8?B?cnN6ZWJyYXM=?= Microsoft Outlook Discussion 2 12th Jul 2006 10:04 PM
Displaying a VBA result in a different worksheet Simon Clark Microsoft Excel Misc 1 27th Apr 2004 02:06 PM
SQL and displaying result 123xxxxx Microsoft Access 2 29th Nov 2003 10:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:26 AM.