How do I allow a multiple selection from a dropdown?

[Monica]

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?

 

[Bernard Liengme]

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

 

[challa prabhu]

Hi,

For more information, please refer to this URL;

http://www.contextures.com/xlDataVal02.html

Challa Prabhu

 

[Monica]

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?

 

[Gord Dibben]

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

 

[Monica]

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]

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

 

[blad3runn69]

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

 

[blad3runn69]

ah ok you needd to use forms

 

[blad3 runn69]

are forms the best way to go? thanks

 

[Dave Peterson]

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.

 

[Gord Dibben]

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