VBA dropdown vs Validation

  • Thread starter Thread starter Slim Slender
  • Start date Start date
S

Slim Slender

What can a VBA generated dropdown on a sheet do that validation can't
do, or what can it do better?
 
Slim Slender explained :
What can a VBA generated dropdown on a sheet do that validation can't
do, or what can it do better?
Click to expand...

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 submitted this idea :
and a ComboBox can contain multiple columns, so more possibilities.
Click to expand...

Excellent! And to add to that...

Any column can be set as BoundColumn, affording a user-friendly list
that returns code-friendly values.
 
DV does not have autocomplete whereas a ComboBox would have.


Gord Dibben MS Excel MVP
 
and also, DV doesn't have AutoSize property as a ComboBox
Click to expand...

Wow, I am convinced that combo boxes are worth the effort.
Thanks to everyone for your responses.
 
Slim Slender wrote on 6/25/2011 :
Wow, I am convinced that combo boxes are worth the effort.
Thanks to everyone for your responses.
Click to expand...

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>
 
Back
Top