+ Reply to Thread
Results 1 to 9 of 9

Display an image based on a cell's value?

  1. #1
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Display an image based on a cell's value?

    EDIT: SOLVED

    Thank You

    I have two bitmap images, and I would like to show only one image at a time, based on the content of another cell's pull-down list. If the user selects "AIR", then display the AIR image. If the user selects "SERVO", then display the SERVO image.

    Is this possible?

    Excel 2000
    Last edited by proepert; 01-13-2010 at 11:14 AM.

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Smile Re: Display an image based on a cell's value?

    Yess offcorce, I'll explain how to do that

    Step 1 Creare a directory
    Create Album sheet consisting of two columns (name and photo) where we can have a directory with pictures. Now you have to give a name to your list, to refer to it in the future.
    1. Go to Insert - Name - Define,
    2. Enter the name (eg DynamicAlbum) and in the address field type belowstated formulae:

    Please Login or Register  to view this content.
    This relatively complex structure is needed to make the source dynamic. If u add a name in the future firmula will catch this name as well. If you know you won't have any names simply point = A1: A5 instead

    Step 2 The drop-down list to select the name
    Go to sheet2, rename as picker and create a cell with a drop-down list to select a name (it will be A1).
    1. Select the cell and go to (Data - Validation
    2. Then iselect list from Allow dropdown
    3. Put cursor in Sorce field and press F3
    4. Select required name (DynamicAlbum).
    5. Press OK:

    Step 3 Copy photograph
    Select the cell with the first photo and hold Shift, click the Edit menu. There should now be an unseen before, Copy image command: Click on it.
    Copy, ir on to Picker sheet in any blank cell, (Edit - Paste).

    Step 4 Create a dynamic link to the selected photo
    Now you need to make a link for points to a cell with dropdown. Open the menu Insert - Name - Define and enter the name of your link, for example, "Picture", and the formula

    Please Login or Register  to view this content.
    Step 5.Tie the photo to link
    The only thing that remains, is to assign this name to the picture in picer sheet.
    Just select the picture and type in the formula bar

    Please Login or Register  to view this content.
    and press Enter


    READY!!!!!!!!!

    I've uploaded a dummy so u can see what I'm talking about. But I think you won't be able to open it. I have to notice that I don't have xl2000 neither at home nor at work...
    Attached Files Attached Files
    Last edited by contaminated; 01-13-2010 at 03:33 AM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, «Born in USSR»
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Forum Contributor
    Join Date
    11-17-2009
    Location
    PA USA
    MS-Off Ver
    Excel 2000
    Posts
    184

    Re: Display an image based on a cell's value?

    Thanks that works real nice. The picture on the 'picker' sheet has a grey border, and the properties are set to no border. Is there any way to remove the border?

  4. #4
    Registered User
    Join Date
    02-14-2011
    Location
    Morgan Hill, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Display an image based on a cell's value?

    How do you perform step 5 in excel 2007?

    I can't put cursor in the formula bar.
    Last edited by YuB; 02-14-2011 at 07:13 PM. Reason: correctspelling

  5. #5
    Registered User
    Join Date
    08-09-2010
    Location
    Podgorje
    MS-Off Ver
    Excel 2010 beta
    Posts
    2

    Re: Display an image based on a cell's value?

    Hi, I have the same problem as YuB except in excel 2010.

    I can't put cursor in the formula bar.

  6. #6
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,222

    Re: Display an image based on a cell's value?

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.
    Quoting entire posts clutters the forum and makes threads hard to read !

  7. #7
    Registered User
    Join Date
    02-17-2012
    Location
    Québec
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Display an image based on a cell's value?

    I can't get this to work, picture won't show up

    i'm not sure about the copy image part, not so clear...

    can someone help?

  8. #8
    Registered User
    Join Date
    11-06-2014
    Location
    Colombia
    MS-Off Ver
    2010
    Posts
    1

    Re: Display an image based on a cell's value?

    works like a charm,

    Thanks!

  9. #9
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Display an image based on a cell's value?

    One more solution.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

+ 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