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

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"DORI" wrote in message
...
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

Thanks for the links Max.
Dori

"Max" wrote:

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"DORI" wrote in message
...
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

You're welcome.
Thanks for the postback ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"DORI" wrote in message
...
Thanks for the links Max.
Dori