Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / Worksheet Functions / November 2005

Tip: Looking for answers? Try searching our database.

function to insert a picture

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
movermike - 17 Nov 2005 17:22 GMT
I am looking for a formula to insert pictureA if X>0, pictureB if X<0.  I
have pasted the pictures at the bottom of my template and have referenced
those cells in the formula, but I dont think it recognizes that there is a
picture in the referenced cell.
Reply to this Message
Peo Sjoblom - 17 Nov 2005 17:40 GMT
One way

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

Signature

Regards,

Peo Sjoblom

> I am looking for a formula to insert pictureA if X>0, pictureB if X<0.  I
> have pasted the pictures at the bottom of my template and have referenced
> those cells in the formula, but I dont think it recognizes that there is a
> picture in the referenced cell.
Reply to this Message
movermike - 17 Nov 2005 23:01 GMT
Tried your macro and got a "Me code error"

> I am looking for a formula to insert pictureA if X>0, pictureB if X<0.  I
> have pasted the pictures at the bottom of my template and have referenced
> those cells in the formula, but I dont think it recognizes that there is a
> picture in the referenced cell.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.