Hi Robert,

Much thanks for your help it works great. I noticed the drop menu
disappears when I click away from the cell it is located inside of but
reappears when I re-click the cell it is located inside of. Is it possible
to set up the drop down menu so that it never disappears even when I am
clicking in other cells?

Thank you for your input,

Eddie

"Robert Martim, Excel" wrote:

Select the target cell; then go to "Data -- Data validation". Insert a
"List" data validation. Type in the list or select the area containing the
list. Click OK and you're ready to go!
--
Robert
Author of RibbonX: Customizing the Office 2007 Ribbon:
FOR THE LATEST TUTORIALS CHECK:
http://www.msofficegurus.com/


"Workbook" wrote:

In cell A2 I want to put a drop down menu/box. In other words I want to be
able to click on a downward arrow in cell A2 and then have the ability to
select from five different options such as I-Phone, Desktop Computer, Laptop
Computer, Touch Screen Monitor, and Wireless Internet Connection.

If I select any one of these options, (such as Touch Screen Monitor) that
selection will appear in cell A2. I guess, I am wondering, is it possible to
create a drop down menu in a single cell and if so can you tell me how?