Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109056
| From | GS <gs@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Multiple selections simultaneously from a data validated dropdown list |
| Date | 2016-07-06 12:29 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <nljbkh$190$1@dont-email.me> (permalink) |
| References | <dsuonblrpd7p4oi8ne5bduhju9971e0qhh@4ax.com> |
> 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
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Multiple selections simultaneously from a data validated dropdown list Phrank <pbeal@hotmail.com> - 2016-07-05 23:36 -0400
Re: Multiple selections simultaneously from a data validated dropdown list GS <gs@v.invalid> - 2016-07-06 12:29 -0400
Re: Multiple selections simultaneously from a data validated dropdown list Phrank <pbeal@hotmail.com> - 2016-07-08 11:06 -0400
Re: Multiple selections simultaneously from a data validated dropdown list GS <gs@v.invalid> - 2016-07-08 11:15 -0400
Re: Multiple selections simultaneously from a data validated dropdown list GS <gs@v.invalid> - 2016-07-08 11:16 -0400
csiph-web