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.
Sweet
Just what I needed today to finish a project.
Now I know why I visit this blog twice a day.
Thanks
For those of you who tried:
The download link was wrong resulting in an empty zip file. Now fixed though.
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