Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109055 > unrolled thread
| Started by | Phrank <pbeal@hotmail.com> |
|---|---|
| First post | 2016-07-05 23:36 -0400 |
| Last post | 2016-07-08 11:16 -0400 |
| Articles | 5 — 2 participants |
Back to article view | Back to microsoft.public.excel.programming
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
| From | Phrank <pbeal@hotmail.com> |
|---|---|
| Date | 2016-07-05 23:36 -0400 |
| Subject | Multiple selections simultaneously from a data validated dropdown list |
| Message-ID | <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
[toc] | [next] | [standalone]
| From | GS <gs@v.invalid> |
|---|---|
| Date | 2016-07-06 12:29 -0400 |
| Message-ID | <nljbkh$190$1@dont-email.me> |
| In reply to | #109055 |
> 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
[toc] | [prev] | [next] | [standalone]
| From | Phrank <pbeal@hotmail.com> |
|---|---|
| Date | 2016-07-08 11:06 -0400 |
| Message-ID | <oagvnb9e2os63p8j0lnbqadl1js4hkiosf@4ax.com> |
| In reply to | #109056 |
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 <gs@v.invalid> 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.
[toc] | [prev] | [next] | [standalone]
| From | GS <gs@v.invalid> |
|---|---|
| Date | 2016-07-08 11:15 -0400 |
| Message-ID | <nlog2a$6ue$1@dont-email.me> |
| In reply to | #109060 |
> 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
[toc] | [prev] | [next] | [standalone]
| From | GS <gs@v.invalid> |
|---|---|
| Date | 2016-07-08 11:16 -0400 |
| Message-ID | <nlog4k$770$1@dont-email.me> |
| In reply to | #109061 |
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
[toc] | [prev] | [standalone]
Back to top | Article view | microsoft.public.excel.programming
csiph-web