+ Reply to Thread
Results 1 to 2 of 2

Display pictures based on cell?

  1. #1
    Registered User
    Join Date
    11-09-2009
    Location
    Thailand
    MS-Off Ver
    Excel 2003
    Posts
    1

    Display pictures based on cell?

    I want the pictures I have to display themselves when the value in cell 'X' is match their own value and that cell is a drop-down list,too.

    I'd tried something like Conditional Format which there is no Rule for displaying picture if "a formula is TRUE" or something like that. I had done some searching and found this http://www.ozgrid.com/forum/showthread.php?t=62575 which is pretty clear describing on making a Conditional Graphic, but I failed on doing that.

    So, I move on to another one http://www.mcgimpsey.com/excel/lookuppics.html
    The example given in the link above is really similar to what I want to do. It made use of Macros and would probably called 'Event Macros' in my case. But, I must admid I don't know anything about Macros or VSB and don't understand anything that is saying in the link above.

    There is another good solution, which still make me feel like an idiot reading the instruction
    http://www.andypope.info/fun/picviewer.htm
    It's an X-Y scatter chart but replaced Data Range with pictures, that's what I think it is.

    So, any idea on my problem. You could guide me with some topic explaining about Macros or describe some solution to me in detail.

    Thanks.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Display pictures based on cell?

    There's more here which I think is more in line with what you want.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ 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