View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default data validation vs combobox

Hi!

Six of one, half dozen of the other!

In some applications you may not want the list to always be visible.

CB's need a linked cell (depending on how you use it)

The range source is a little more complicated to define in CB's if you want
variable sources.

Both serve their own purpose!

Biff

"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!