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?

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?

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?

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?

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?

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?

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?

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

doh
 

ah ok you needd to use forms :)

forms?
 

are forms the best way to go? thanks

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

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