Drop Down List - Select Multiple Items

[VLH]

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?

 

[Per Jessen]

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]

Hello,
Can you instruct me on where to find the "properties window" please?
Thanks!

 

[Gord Dibben]

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

 

[VLH]

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]

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

 

[tduyhao]

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








- 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.

 

[Gord Dibben]

I am not familiar with what you describe.

Note: I do not do much programming so my knowledge is limited.

Perhaps someone will recognize the process from your description?

Maybe a userform or similar?


Gord

 

[anubha.b28]

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

 

[kremzir]

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.

 

[gourav.pahuja]

<script>hi</script>