| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA dropdown vs Validation
and a ComboBox can contain multiple columns, so more possibilities.
-- isabelle |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA dropdown vs Validation
and also, DV doesn't have AutoSize property as a ComboBox
-- isabelle |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation-dropdown | Excel Discussion (Misc queries) | |||
| Multiselect Validation (dropdown) | Excel Discussion (Misc queries) | |||
| How to know if a validation dropdown exist | Excel Programming | |||
| dropdown with validation?? | Excel Worksheet Functions | |||
| Validation Dropdown List | Excel Programming | |||
![Slim Slender[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
