« Advanced Range Detection
Encryption Concepts »

Showing a picture from a list of pictures

17th May 2005, 08:58 am by jkpieterse

Many people keep part lists in Excel.

Sometimes even with embedded pictures next to the part data.

This article demonstrates a method to show a picture on a sheet that changes when a different part number is chosen from the list of available part numbers.

Category: General  |  Comment (RSS)  |  Trackback

3 Comments

  1. Jim:

    Sweet
    Just what I needed today to finish a project.
    Now I know why I visit this blog twice a day.
    Thanks

    17 May 2005, 9:07 am

  2. jkpieterse:

    For those of you who tried:

    The download link was wrong resulting in an empty zip file. Now fixed though.

    17 May 2005, 10:49 am

  3. Jason Morin:

    Nice and simple. The other 2 methods I’ve seen are from J.E. McGimpsey:

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

    which uses a combination of validation and a Worksheet_Calculation event.

    The other is from Andy Pope. He uses a XY Scatter Chart and a Forms listbox (I think).

    http://www.andypope.info/fun/picviewer.htm

    17 May 2005, 11:03 am

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment