How to create a drop down menu for objects

[Guest]

Is it possible to create a drop down menu for objects in the worksheet? I
have a worksheet that students enter some data in it and then, they have to
draw some simple logos in relation to the result of data. I have made the
logos (a total of 20)using the drawing tool and have put them on the
worksheet so that students can mouse-drag them to the designated locations. I
though if I can create a drop-down menu and put all the objects in it, the
worksheet would like very clean and easy to work with.
Thanks for your help or any comments in advance.
Dori

 

[Max]

Here's 2 options to browse through ..

a. Try JE's:
http://www.mcgimpsey.com/excel/lookuppics.html
Looking up and displaying a picture based on a cell value
(there's a link to a sample at the bottom of the page)

b. Try this post by Bob Phillips
where he provides the code to retrieve pictures
via data validation selections to a location near the DV cell:
http://tinyurl.com/degut

A demo file with Bob's sub implemented is available at:
http://www.savefile.com/files/8341414
Select n Retrieve Pictures using DV.xls

 

[Guest]

Thanks for the links Max.
Dori

Here's 2 options to browse through ..

a. Try JE's:
http://www.mcgimpsey.com/excel/lookuppics.html
Looking up and displaying a picture based on a cell value
(there's a link to a sample at the bottom of the page)

b. Try this post by Bob Phillips
where he provides the code to retrieve pictures
via data validation selections to a location near the DV cell:
http://tinyurl.com/degut

A demo file with Bob's sub implemented is available at:
http://www.savefile.com/files/8341414
Select n Retrieve Pictures using DV.xls

 

[Max]

You're welcome.
Thanks for the postback ..