Hi,

I've got my spreadsheet set where users are able to select multiple
values from a data validated dropdown list one at a time. All values
selected show up in the cell as expected, separated by a comma. But,
the user has to select each value one at a time, reselecting the
dropdown list each time. Is there an easy way to set it up so that
the user can select all values at the same time, similar to a filtered
list drop down (except everything starts out unselected)?

I believe this can be done almost totally with VBA (have a single
'option' that fires a VBA multi-select dropdown list that concatenates
all the selections and pastes the result in the cell), but I'm hoping
there's an easier solution. Thanks!

Frank

Hi,

I've got my spreadsheet set where users are able to select multiple
values from a data validated dropdown list one at a time. All values
selected show up in the cell as expected, separated by a comma. But,
the user has to select each value one at a time, reselecting the
dropdown list each time. Is there an easy way to set it up so that
the user can select all values at the same time, similar to a
filtered list drop down (except everything starts out unselected)?

I believe this can be done almost totally with VBA (have a single
'option' that fires a VBA multi-select dropdown list that
concatenates all the selections and pastes the result in the cell),
but I'm hoping there's an easier solution. Thanks!

Frank

Using a VBA multiselect listbox is the easiest way, IMO. Not sure what
you mean by "easier solution" unless it's how you code for this.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Ok. I was just wondering if there was something built in that I
wasn't aware of and didn't find. I'll go the VBA listbox route.
Thanks Garry.


On Wed, 06 Jul 2016 12:29:03 -0400, GS wrote:

Hi,

I've got my spreadsheet set where users are able to select multiple
values from a data validated dropdown list one at a time. All values
selected show up in the cell as expected, separated by a comma. But,
the user has to select each value one at a time, reselecting the
dropdown list each time. Is there an easy way to set it up so that
the user can select all values at the same time, similar to a
filtered list drop down (except everything starts out unselected)?

I believe this can be done almost totally with VBA (have a single
'option' that fires a VBA multi-select dropdown list that
concatenates all the selections and pastes the result in the cell),
but I'm hoping there's an easier solution. Thanks!

Frank

Using a VBA multiselect listbox is the easiest way, IMO. Not sure what
you mean by "easier solution" unless it's how you code for this.

Ok. I was just wondering if there was something built in that I
wasn't aware of and didn't find. I'll go the VBA listbox route.
Thanks Garry.

You're welcome!
I typically would use the sheet's BeforeBoubleClick OR BeforeRightClick
of the target cell to display the list. Optionally, a keyboard combo!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Typo...

Ok. I was just wondering if there was something built in that I
wasn't aware of and didn't find. I'll go the VBA listbox route.
Thanks Garry.

You're welcome!

I typically would use the sheet's BeforeDoubleClick OR

BeforeRightClick of the target cell to display the list. Optionally,
a keyboard combo!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus