VBA dropdown vs Validation

[Slim Slender]

What can a VBA generated dropdown on a sheet do that validation can't
do, or what can it do better?

 

[GS]

Slim Slender explained :

What can a VBA generated dropdown on a sheet do that validation can't
do, or what can it do better?

Just off the top of my head.., a combobox generated by VBA could
execute code when a selection is made. A DV dropdown can't do that and
so would require using a worksheet event.

 

[isabelle]

and a ComboBox can contain multiple columns, so more possibilities.

 

[GS]

isabelle submitted this idea :

and a ComboBox can contain multiple columns, so more possibilities.

Excellent! And to add to that...

Any column can be set as BoundColumn, affording a user-friendly list
that returns code-friendly values.

 

[Gord Dibben]

DV does not have autocomplete whereas a ComboBox would have.


Gord Dibben MS Excel MVP

 

[isabelle]

and also, DV doesn't have AutoSize property as a ComboBox

 

[Slim Slender]

and also, DV doesn't have AutoSize property as a ComboBox

Wow, I am convinced that combo boxes are worth the effort.
Thanks to everyone for your responses.

 

[GS]

Slim Slender wrote on 6/25/2011 :

Wow, I am convinced that combo boxes are worth the effort.
Thanks to everyone for your responses.

Well.., there's going to be some extra overhead to maintain. Also, if
you plan to use the method exampled on Debra Dalgleish's website you'll
need to fix it somewhat so it doesn't misbehave on you when users
change selection.

What I do is show a userform with the combobox OR use DV and provide a
popup context menu depending on the user's choice made in the DV
dropdown. Not as 'slick' as Debra's solution but more easy to
manage/control and no misbehavior issues either!<g>