VBA dropdown vs Validation
 

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

VBA dropdown vs Validation
 

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

VBA dropdown vs Validation
 

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

--
isabelle

VBA dropdown vs Validation
 

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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

VBA dropdown vs Validation
 

DV does not have autocomplete whereas a ComboBox would have.


Gord Dibben MS Excel MVP

On Thu, 23 Jun 2011 17:10:14 -0700 (PDT), Slim Slender
wrote:

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

VBA dropdown vs Validation
 

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

--
isabelle

VBA dropdown vs Validation
 

On Jun 24, 12:41*am, isabelle wrote:
and also, DV doesn't have AutoSize property as a ComboBox

--
isabelle

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

VBA dropdown vs Validation
 

Slim Slender wrote on 6/25/2011 :
On Jun 24, 12:41*am, isabelle wrote:
and also, DV doesn't have AutoSize property as a ComboBox

--
isabelle

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[s].

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc