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.

**VBA Noob** · 12-04-2007, 05:42 PM

There were 3 links what worked ??

VBA Noob

**Althar** · 12-04-2007, 06:03 PM

Oh sorry. The first one
http://www.mcgimpsey.com/excel/lookuppics.html

**VBA Noob** · 12-04-2007, 06:32 PM

See if the attached helps. To big to add here

http://www.savefile.com/files/1242427

VBA Noob

**Althar** · 12-04-2007, 06:50 PM

Getting closer hehe ! =)

It works but it won't show the picture on the first one if I chose the same item in both lists =/

**VBA Noob** · 12-04-2007, 06:54 PM

If you want to use the same picture take a copy and then rename it.

E.g if the Picture you want to use twice is called Picture 1 then copy it and while selected go to the name box next to the formula bar and change to say Picture 5

HTH

VBA Noob

**Althar** · 12-04-2007, 07:08 PM

Well...any way to make that automatic. I kinda have 100 pictures and won't do that manually everytime the same is used. It has to do it by itself =/

**VBA Noob** · 12-04-2007, 07:15 PM

100 pictures may not work with this method I recall.

You can give it a ok thou. I assume your pictures already have names so simply create your table as shown in sheet 2 with the person's name and the picture name. Shouldn't take long

or better still use Ron's code (link 2). Save the pictures in a shared area and then download this add-in to list the picture names

http://www.tushar-mehta.com/excel/so...ist/index.html

VBA Noob

**VBA Noob** · 12-04-2007, 07:22 PM

Link may be of interest

http://www.excelforum.com/showthread.php?t=585882

VBA Noob

**Althar** · 12-04-2007, 07:28 PM

It is already like that. I made a sheet with the name list followed by the image list. Used a look up function to determine wich picture it should show according to what has been chosen in the list. Both list use the same sheet and the same pictures but it just won't show the picture twice if I chose the same item in both lists. See my attachments

Edit : They all display fine on both list. Don't have any problems with the amount I have. It just won't show the first picture if both list have the same item selected.