Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
How do I allow a multiple selection from a dropdown?
I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
You have a Data Validation list with items: apple, pear, peach, plum
You want the user to be able to select more than one in a single cell: apple peach ? Not possible or did I misunderstand the question? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monica" wrote in message ... How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
Hi,
For more information, please refer to this URL; http://www.contextures.com/xlDataVal02.html Challa Prabhu "Monica" wrote: How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
That's correct Bernard. I want to choose and display apple & peach in the
same cell but it doesn't allow me to. I can only choose one of them at the time. Any ideas why? "Bernard Liengme" wrote: You have a Data Validation list with items: apple, pear, peach, plum You want the user to be able to select more than one in a single cell: apple peach ? Not possible or did I misunderstand the question? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monica" wrote in message ... How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
Monica
See Debra Dalgleish's site for a sample workbook showing how to select multiple entries from a DV list dropdown. http://www.contextures.com/excelfiles.html#DataVal DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07 Gord Dibben MS Excel MVP On Tue, 7 Aug 2007 06:08:06 -0700, Monica wrote: That's correct Bernard. I want to choose and display apple & peach in the same cell but it doesn't allow me to. I can only choose one of them at the time. Any ideas why? "Bernard Liengme" wrote: You have a Data Validation list with items: apple, pear, peach, plum You want the user to be able to select more than one in a single cell: apple peach ? Not possible or did I misunderstand the question? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monica" wrote in message ... How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
Thank You very much for that link - it's excellent!
I have my dropdown working now. The only problem is that the code applies to one column only. I tried to change the code but it does not allow me to. Is that because the workbook is protected? Could you help me to change the code so that it could be applied to more than one column in the worksheet please? Best Regards! "Gord Dibben" wrote: Monica See Debra Dalgleish's site for a sample workbook showing how to select multiple entries from a DV list dropdown. http://www.contextures.com/excelfiles.html#DataVal DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07 Gord Dibben MS Excel MVP On Tue, 7 Aug 2007 06:08:06 -0700, Monica wrote: That's correct Bernard. I want to choose and display apple & peach in the same cell but it doesn't allow me to. I can only choose one of them at the time. Any ideas why? "Bernard Liengme" wrote: You have a Data Validation list with items: apple, pear, peach, plum You want the user to be able to select more than one in a single cell: apple peach ? Not possible or did I misunderstand the question? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monica" wrote in message ... How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow a multiple selection from a dropdown?
You can change the Target.Column line in the code.
If Target.Column < 27 Then Will now work on any DV list in Columns A:Z If need more specific column range, post back. Gord On Wed, 8 Aug 2007 03:00:02 -0700, Monica wrote: Thank You very much for that link - it's excellent! I have my dropdown working now. The only problem is that the code applies to one column only. I tried to change the code but it does not allow me to. Is that because the workbook is protected? Could you help me to change the code so that it could be applied to more than one column in the worksheet please? Best Regards! "Gord Dibben" wrote: Monica See Debra Dalgleish's site for a sample workbook showing how to select multiple entries from a DV list dropdown. http://www.contextures.com/excelfiles.html#DataVal DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07 Gord Dibben MS Excel MVP On Tue, 7 Aug 2007 06:08:06 -0700, Monica wrote: That's correct Bernard. I want to choose and display apple & peach in the same cell but it doesn't allow me to. I can only choose one of them at the time. Any ideas why? "Bernard Liengme" wrote: You have a Data Validation list with items: apple, pear, peach, plum You want the user to be able to select more than one in a single cell: apple peach ? Not possible or did I misunderstand the question? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Monica" wrote in message ... How do I allow a multiple selection from a dropdown? I know how to create a list / dropdown with multiple options but now the question is - how can I choose more than one option?? I know that usually it works by pressing CTR, scrolling down the list and choosing mulitple options. But how do I apply it to the Excel worksheet? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select Multiple Items from Dropdown List
the linked example does not really answer the ? being asked. How can you select multiple items from the list like a multiselect listbox in ms access?
thanks |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
doh
ah ok you needd to use forms :)
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
forms?
are forms the best way to go? thanks
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select Multiple Items from Dropdown List
You could use a listbox from the Forms toolbar on a worksheet.
Or you could use a listbox from the Control Toolbox toolbar on a worksheet. In either case, you'd need code to get the selected items from the listbox and into a range on a worksheet. Or you could use a userform. Depends on what you want to do. blad3runn69 wrote: the linked example does not really answer the ? being asked. How can you select multiple items from the list like a multiselect listbox in ms access? thanks -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select Multiple Items from Dropdown List
What linked example and what question?
http://www.contextures.on.ca/excelfiles.html#DataVal DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a dropdown list; an event macro stores selections in adjacent cell, or in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07 Gord Dibben MS Excel MVP On Thu, 17 Apr 2008 02:32:18 -0700, blad3runn69 wrote: the linked example does not really answer the ? being asked. How can you select multiple items from the list like a multiselect listbox in ms access? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you lock a cell after making a selection from a dropdown b | Excel Worksheet Functions | |||
Allow selection of multiple values in dropdown list in excel | Excel Discussion (Misc queries) | |||
Insert Picture from dropdown selection | New Users to Excel | |||
Dropdown list key selection | Excel Discussion (Misc queries) | |||
Dropdown selection crashes | Excel Worksheet Functions |