+ Reply to Thread
Results 1 to 5 of 5

Looking up and displaying a picture based on a cell value

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    Southampton
    MS-Off Ver
    Excel 2010
    Posts
    4

    Looking up and displaying a picture based on a cell value

    Hi all. I'm a complete noob to Excel programming, and not much of a user of Excel in general. With that in mind, I'm hoping someone can help me here.

    Following this guide:
    http://www.mcgimpsey.com/excel/lookuppics.html

    I've managed to set up my own workbook with a dropdown list in a cell prompting the display of the corresponding picture to display on the worksheet, just like in the guide.

    However, my question is, how can I have another separate dropdown list showing it's own linked pictures? At the moment the macro hides all images excluding the one in the lookup cell. Thanks.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Looking up and displaying a picture based on a cell value

    You should post your current macro. McGimpsey's code starts out by hiding all the pictures and then displays the one associated with the drop-down.

    It would have to be modified to hide only some of the pictures.
    Gary's Student

  3. #3
    Registered User
    Join Date
    05-10-2013
    Location
    Southampton
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Looking up and displaying a picture based on a cell value

    Thanks for the prompt reply Jakob.

    I've managed to get something working now, it is as follows:
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    05-10-2013
    Location
    Southampton
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Looking up and displaying a picture based on a cell value

    Hi all again. Does anyone know of a workaround to avoid any new images being hidden using the above method?

    Maybe a way to hide specific images only, or within a certain range of images leaving new images outside that range unaffected? At the moment if I add a new image, it will be hidden when the macro next runs (unless I add a line to the macro specifying it as visible which is less than idea). Thanks

  5. #5
    Registered User
    Join Date
    05-10-2013
    Location
    Southampton
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Looking up and displaying a picture based on a cell value

    Bump, any ideas?

+ 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