There's an example here that combines the advantages of both, using
cells with data validation lists, and one combobox:

http://www.contextures.com/xlDataVal11.html

paul wrote:
hello there excel gurus.I am largely self taught in excel and can write
straightforward macros and have a pretty good grasp of some of the
functions.I have always used form comboboxes for my pull down lists.I notice
that you seem to prefer the data validation list,pros and cons.?I like that
the fom combo box is always there.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html