+ Reply to Thread
Results 1 to 2 of 2

Control the display of a picture using a formula / Insert image with IF statement

  1. #1
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,088

    Control the display of a picture using a formula / Insert image with IF statement

    I recently saw a thread started in 2009 by BRISBANEBOB asking:

    Is it possible to insert an image (such as Picture1 which is the name of an image created by Insert>Name>Define) using an IF statement as in:

    =IF(A1=B1,+Picture1,"")
    The thread was entitled: Insert image with IF statement

    Chance2 provide a solution the next day that clearly resolved BRISBANEBOB's question, although the thread is not marked Solved


    The reason for posting this new thread is that the original thread was revived in the middle of last year and again today (09 January 2013). The thread has been viewed over 4000 times ... but the recent updates indicated some dissatisfaction with the explanation.

    I decided to play around with the example which, I must add, worked straight out of the box, for my own benefit and edification. I have tried to clarify the explanation of the steps necessary and also how to create the necessary Named Ranges, which may be the source of the confusion.

    The results of my efforts are attached for anyone who might want to implement something similar. I should thank BRISBANEBOB for asking the question, and Chance2 again for providing the solution (rep in the post )

    Enjoy!

    Regards, TMS
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  2. #2
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Control the display of a picture using a formula / Insert image with IF statement

    I tried this instead of using copy/paste with vba, which I thought would be more efficient and make things run quicker, but for some reason, I've gone from about 2 seconds to 10 seconds in the spreadsheet using this method. Can anyone suggest why? Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1