Creating a drop down list of clip art type images in excel

**S12345** · 02-10-2013, 03:47 PM

Hi
Does anyone know how to do the following:

I want to create a drop down list in excel where the choices are pictures (clip art style) rather than numbers, letters, words etc.

I only want to use a maximum of 5 pictures per column e.g. column b would have a drop down list of pictures of say cat, dog, mouse , column c would have pictures of say smiley face, sad face, indifferent face.

I have done some searching and found threads referning to possible methods including look up tables and macros e.g. http://mcgimpsey.com/excel/lookuppics.html

But at my level of excel experience I would need a bit more step by step guidance from the beginning if anyone has the time would be much appreciated!

Thanks

**mrice** · 02-10-2013, 04:56 PM

Please have a look at the attached. I've indicated on the various tabs in the VBA editor where you will need to add the detail.

**S12345** · 02-10-2013, 05:28 PM

Thanks very much for the download
I'm not familiar with this aspect other than correcting when running a debug for a macro that helps to hide and show columns.
Could you give me a bit more info on what I do next please? e.g. where I put the pics etc?
Thanks again

**mrice** · 02-11-2013, 02:50 PM

The pictures are inserted into the drop down by the code in Sheet1.

As a starting point, I suggest that you change both occurrences of the the c:\temp\... path in Sheet1 in the VBA editor to point to a file on your file system.

Then click into column A and select the top picture.

This should give you an idea of what is going on.

**harveycald** · 04-30-2015, 06:14 AM

I have been searching for a solution to this for a long time. I have altered the code to point to the images but only get one image in the dropdown. How do I get the dropdown to show the 5 images and put the selected one in the column with the cursor in?

**FDibbins** · 04-30-2015, 11:05 AM

Harvey, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.