OK, I got this far. Now the question is, How do I get the text to show that I
have selected in the drop down list, as oppose to a value? (1,2,3...)

"T. Valko" wrote:

Use a combo box from the Forms toolbar.

--
Biff
Microsoft Excel MVP


"tracy" wrote in message
...
I have created a simple drop down list. I would like the drop down arrow to
appear in the spread sheet all the time, without it being necessary to
select
the cell. Is this possible?