Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Multiple selections simultaneously from a data validated dropdown list

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Multiple selections simultaneously from a data validated dropdown list

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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 153
Default Multiple selections simultaneously from a data validated dropdown list

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.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Multiple selections simultaneously from a data validated dropdown list

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

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Multiple selections simultaneously from a data validated dropdown list

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
counting dropdown list with multiple text selections Robin Excel Discussion (Misc queries) 0 August 14th 09 04:06 PM
multiple dropdown selections Oct1196 Excel Worksheet Functions 3 September 6th 07 05:38 PM
Remove old selections in Pivottable row field dropdown list Mark Purvis Excel Programming 1 February 16th 06 04:57 PM
How to validate data in already list dropdown validated. Rao Ratan Singh Excel Discussion (Misc queries) 2 June 14th 05 01:32 PM
How can I allow users to make multiple selections from a dropdown. Liz Excel Worksheet Functions 0 February 17th 05 06:21 AM


All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"