 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005How to create a drop down menu for objects
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 -- > 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 [quoted text clipped - 5 lines] > Thanks for your help or any comments in advance. > Dori Thanks for the links Max. Dori > Here's 2 options to browse through .. > [quoted text clipped - 32 lines] > > 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 -- > Thanks for the links Max. > Dori |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.