associate pictures with items in a list

**Althar** · 12-04-2007, 01:37 PM

Hello everyone.

I was wondering if there is anyway to associate pictures with items in a list. Let me explain a little.

I need to make pictures change according to what the user selects in a list.
Ex: User selects item #1, picture associated to item #1 appears in the top left corner, item#2, picture #2 in top left corner, etc.

I tried using a normal search function but found out you can't associate a picture to a cell (or maybe????) so can't use a search function to associate a picture to the item as I did with the price. Is there any way to do it?

Edit : Using excel 2007 *

**VBA Noob** · 12-04-2007, 02:13 PM

See if links help

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

Look under ....Insert Pictures from Folder

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

VBA Noob

**Althar** · 12-04-2007, 05:38 PM

It worked !!! But is there a way to do that twice in the same page?

I have 2 lists using the same lookup table. I was able to make it work with the first list, pictures show up as they should when I chose an item from the list but I would like to do the same thing with a second list that is located on the same page. It uses the same table with the same items and pictures.