You would have to use a different type of drop down. You could use a Forms
toolbar combo box. The drop arrow is always visible with this type of drop
down however, it woks differently from a data validation drop down list.

A DV drop down automatically sizes to fit a cell. With a combo box, you have
to "draw" it to the size and shape you want it.

Here are some notes I wrote about the differences:

Combo box vs data validation drop down list differences

The main difference between a combo box and a data validation drop down list
is that a combo box does not occupy a cell. A combo box "floats" above the
worksheet. A data validation drop down list does occupy a cell. So, when you
make a selection from a data validation drop down list that selection is
entered as the value of the cell. When you make a selection from a combo box
(there are 2 types of combo boxes) that selected value is not entered into
any cell
automatically. You have to "format" the combo box to enter the selection in
a cell and the cell can be any cell of your choice. The cell that will hold
the selection is called the linked cell. In other words, this cell is linked
to this combo box.

Now comes the fun part!

As I said, there are 2 types of combo boxes, a Forms Toolbar combo box and a
Control Toolbox combo box. Each of these handles the linked cell a different
way. A Forms combo box will return the index number of the selection to the
linked cell. A Control combo box will return the actual selection to the
linked cell. For example:

Tom
Bill
Sue
Lisa

Let's say you select Sue from the combo box. If it's a Forms cb, then the
linked cell will return the index number 3 because Sue is the 3rd item in
the cb. A Control cb will return the actual selection Sue to the linked
cell.

So, if you need a formula that uses the selection from the cb you have to
reference the linked cell. If it's a Control cb then the reference is pretty
straightforward. If it's a Forms cb then you have to "translate" the
selection index number to the actual selection. In other words, you have to
somehow make 3 = Sue.

The easiest way to do this is to use an INDEX function. You would index the
source of the cb and use the linked cell to tell INDEX which value you want.

Suppose the list of names above is in the range A1:A4 and has the defined
name of Names. The source of the cb would be Names. Let's assume the linked
cell is B1. To do your lookup:

=VLOOKUP(A2,sheet2!A1:E22,COLUMNS(A:B),0)

If it's Control cb:

=VLOOKUP(B1,sheet2!A1:E22,COLUMNS(A:B),0)

If it's Forms cb:

=VLOOKUP(INDEX(Names,B1),sheet2!A1:E22,COLUMNS(A:B ),0)

Here's another "neat" thing about combo boxes. Since they "float" above the
worksheet you can "hide" stuff under them. This is the perfect location for
the lnked cell.


--
Biff
Microsoft Excel MVP


"Workbook" wrote in message
...
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?