Lookup Images with VBA

[Michael Marshall]

I have a cabinet quotation spreadsheet that offers 22 door styles. We never need to quote more than 6 or so. showing all 22 doors is impractical now. What I want to do is make 6 selections from 6 pull down menus (menues showing all 22 door styles). Upon making a selection for door 1, I want it's image to appear. Same for door selections 2 through 6.

I did find some code from McGimpsey & Assoctiates (http://www.mcgimpsey.com/excel/lookuppics.html), that works, however, it is only good for 1 image per tab. My application needs mulitiple selections as described above.

My question \ request, is how do I modify the McGimpsey code to allow for multiple images to be controlled by a pull down menu?