Paul: There's bunches of companies who don't let their users run macros, for
one. For another, Data Validation is, IMHO, much easier to show someone how
to do. Comboboxes ALWAYS show their dropdown arrow. Comboboxes are harder to
size to a cell. Hmm...what else? :)
************
Anne Troy
www.OfficeArticles.com

"paul" wrote in message
...
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.
--
paul
remove nospam for email addy!