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