Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
Hi
If you use a List Box it's possible to allow mulit select. Open the properties window and find the field MultiSelect and enter the value to "1 - fmMultiSelectMulti" Regards, Per "VLH" skrev i meddelelsen ... I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
Hello,
Can you instruct me on where to find the "properties window" please? Thanks! "Per Jessen" wrote: Hi If you use a List Box it's possible to allow mulit select. Open the properties window and find the field MultiSelect and enter the value to "1 - fmMultiSelectMulti" Regards, Per "VLH" skrev i meddelelsen ... I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
See Debra Dalgleish's site for a workbook download showing how to select
multiple items from a DV list. 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 http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote: I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
I have viewed Debra's DV0017 workbook and the instructions only say to
right-click on the worksheet tab to view the code. It doesn't tell me what function to place in my worksheet so that I receive multiple items from a drop-down. Please help me understand what I should do with Debra's DV0017 to ensure I get multiple items from a drop-down into my worksheet. Thanks! "Gord Dibben" wrote: See Debra Dalgleish's site for a workbook download showing how to select multiple items from a DV list. 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 http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote: I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
You need to set a cell or cells as a DV Dropdown with a list then alter the code
to point to that DV Dropdown cell or column. From your original post I believe you should concentrate on the Comma Separated worksheet code Perhaps you should see Debra's site for how to create a DV dropdown list first before altering any of her code. http://www.contextures.on.ca/xlDataVal01.html Now, to the workbook you downloaded...................... Have you tested by clicking on one of the DV dropdowns on the Comma Separated sheet. Debra provides with the MultiSelect workbook. Where will your DV dropdown cells be located? Where will you store the DV list? These I need to know before going any further but you could experiment with changing this line If Target.Column = 3 Then..........the 3 points to any DV Dropdown in Column C Change to your column. Gord On Thu, 1 May 2008 07:59:00 -0700, VLH wrote: I have viewed Debra's DV0017 workbook and the instructions only say to right-click on the worksheet tab to view the code. It doesn't tell me what function to place in my worksheet so that I receive multiple items from a drop-down. Please help me understand what I should do with Debra's DV0017 to ensure I get multiple items from a drop-down into my worksheet. Thanks! "Gord Dibben" wrote: See Debra Dalgleish's site for a workbook download showing how to select multiple items from a DV list. 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 http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben MS Excel MVP On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote: I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
On May 1, 6:49*am, Gord Dibben <gorddibbATshawDOTca wrote:
See Debra Dalgleish's site for a workbook download showing how to select multiple items from a DV list. 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 http://www.contextures.on.ca/excelfiles.html#DataVal Gord Dibben *MS Excel MVP On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote: I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. * For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? *- Hide quoted text - - Show quoted text - Dear Gord Dibben, I've got the same problem and while searching on the Internet to find out anyway to get a drop-down list with check-box element inside, I found this article but it is still not exactly what I would like to have.. I've already seen somebody using a speadsheet with a multichoice drop- down list, it looks like a autofilter fucntion and allow you to select more than one criteria for your filtration. when you click on the arrow on right side of the cell, it show you a drop-down list with all the check-boxes in side the list, then you can select whatever item by click on approriate checkbox. And at the bottom of the dropdown list, there is 2 buttons, OK and Cancel, if you select OK, then the Filtration process will start with all the criteria you've selected in checkboxes inside that drop-down list. I really want to know how to get this done, even by VBA macro but I could not find anything like this on the internet. I really appreciated if you can help me to point out where is the right direction to find any solutions for this problem. Thank you very much and look forward to your feedback soon.. Best regards, Hao. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
Hi Hao,
Were you able to find a solution to your problem of having a list of checkboxes in a dropdown list in excel? Thanks Anubha |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
I realize this thread is kind of old but I was just trying to figure out the same and figured it out. I'm on Office 2010, just go tthe "data" tab and then click on the "filter" button. On my spreadsheet it automatically pulled all the column data and created the checkbox. hope this helps.
On Wednesday, January 8, 2014 9:07:41 PM UTC-8, wrote: Hi Hao, Were you able to find a solution to your problem of having a list of checkboxes in a dropdown list in excel? Thanks Anubha |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
<scripthi</script
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
On Wednesday, April 30, 2008 5:00:02 PM UTC-4, Per Jessen wrote:
Hi If you use a List Box it's possible to allow mulit select. Open the properties window and find the field MultiSelect and enter the value to "1 - fmMultiSelectMulti" Regards, Per "VLH" skrev i meddelelsen ... I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? I have also been trying to be able to select multiple items from a drop-down menu and have them show up in the same cell and cannot figure out how it is done. Where is the "properties window?" Is this a change that should be applied to the entire document or should the column with the drop-down menu be highlighted when I enter the "1 - fmMultiSelectMulti" value? |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
See Debra Dalgleish's solution.
http://www.contextures.on.ca/excel-d...-multiple.html Gord On Wed, 19 Nov 2014 10:53:43 -0800 (PST), wrote: On Wednesday, April 30, 2008 5:00:02 PM UTC-4, Per Jessen wrote: Hi If you use a List Box it's possible to allow mulit select. Open the properties window and find the field MultiSelect and enter the value to "1 - fmMultiSelectMulti" Regards, Per "VLH" skrev i meddelelsen ... I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? I have also been trying to be able to select multiple items from a drop-down menu and have them show up in the same cell and cannot figure out how it is done. Where is the "properties window?" Is this a change that should be applied to the entire document or should the column with the drop-down menu be highlighted when I enter the "1 - fmMultiSelectMulti" value? |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
And here is my solution: completely free and easy to understand.
http://www.vlsiip.com/exceltips.html On Friday, November 21, 2014 at 3:48:21 PM UTC, Gord Dibben wrote: See Debra Dalgleish's solution. http://www.contextures.on.ca/excel-d...-multiple.html Gord On Wed, 19 Nov 2014 10:53:43 -0800 (PST), wrote: On Wednesday, April 30, 2008 5:00:02 PM UTC-4, Per Jessen wrote: Hi If you use a List Box it's possible to allow mulit select. Open the properties window and find the field MultiSelect and enter the value to "1 - fmMultiSelectMulti" Regards, Per "VLH" skrev i meddelelsen ... I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? I have also been trying to be able to select multiple items from a drop-down menu and have them show up in the same cell and cannot figure out how it is done. Where is the "properties window?" Is this a change that should be applied to the entire document or should the column with the drop-down menu be highlighted when I enter the "1 - fmMultiSelectMulti" value? |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down List - Select Multiple Items
On Wednesday, 30 April 2008 21:48:01 UTC+1, VLH wrote:
I need to select multiple items from a drop-down list that I created because there are times where more than one item is needed. For example, my drop-down list might contain the following: apples, oranges, pears, lemons, mangos I want the data cell to show that I selected: apples, oranges, pears (for example). Is this possible? -- Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential. If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way. This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989. Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at:http://www.morrisons.co.uk/gscop <http://www.morrisons.co.uk/gscop Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting multiple items from drop-down list | Excel Discussion (Misc queries) | |||
Can I create a dropdown list to select multiple items | Excel Worksheet Functions | |||
Selecting multiple items from a drop down list | Excel Discussion (Misc queries) | |||
select multiple items from a dropdown list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |