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