Using the subject as if it is the question.

see
Excel -- Data Validation -- Combo box using Named Ranges
http://www.contextures.com/xlDataVal11.html
http://www.contextures.com/tiptech.html

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"pull down menues in a cell" <pull down menues in a wrote in message
...