Microsoft Office Forums


Reply
Thread Tools Display Modes

How do I allow a multiple selection from a dropdown?

 
 
Monica
Guest
Posts: n/a
 
      08-07-2007, 11:44 AM
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?
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      08-07-2007, 11:51 AM
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" <(E-Mail Removed)> wrote in message
news08C1880-44A3-4F1D-BF68-(E-Mail Removed)...
> 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?



 
Reply With Quote
 
 
 
 
challa prabhu
Guest
Posts: n/a
 
      08-07-2007, 12:04 PM
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?

 
Reply With Quote
 
Monica
Guest
Posts: n/a
 
      08-07-2007, 01:08 PM
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" <(E-Mail Removed)> wrote in message
> news08C1880-44A3-4F1D-BF68-(E-Mail Removed)...
> > 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?

>
>
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      08-07-2007, 03:17 PM
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 <(E-Mail Removed)>
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" <(E-Mail Removed)> wrote in message
>> news08C1880-44A3-4F1D-BF68-(E-Mail Removed)...
>> > 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?

>>
>>
>>


 
Reply With Quote
 
Monica
Guest
Posts: n/a
 
      08-08-2007, 10:00 AM
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 <(E-Mail Removed)>
> 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" <(E-Mail Removed)> wrote in message
> >> news08C1880-44A3-4F1D-BF68-(E-Mail Removed)...
> >> > 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?
> >>
> >>
> >>

>
>

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      08-08-2007, 09:24 PM
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 <(E-Mail Removed)>
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 <(E-Mail Removed)>
>> 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" <(E-Mail Removed)> wrote in message
>> >> news08C1880-44A3-4F1D-BF68-(E-Mail Removed)...
>> >> > 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?
>> >>
>> >>
>> >>

>>
>>


 
Reply With Quote
 
blad3runn69
Guest
Posts: n/a
 
      04-17-2008, 09:32 AM
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 With Quote
 
blad3runn69
Guest
Posts: n/a
 
      04-17-2008, 09:33 AM
ah ok you needd to use forms
 
Reply With Quote
 
blad3 runn69
Guest
Posts: n/a
 
      04-17-2008, 09:41 AM
are forms the best way to go? thanks
 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to select display multiple records and allow selection of just 1 for input to second table Steve Access Forms 0 08-04-2008 12:52 AM
Copy Selection - Paste Selection - Delete Selection Uninvisible Excel Programming 2 10-25-2007 12:31 PM
Copy Selection - Transpose Selection - Delete Selection Uninvisible Excel Misc 2 10-23-2007 03:18 PM
Allow selection of multiple values in dropdown list in excel Nancy @ CHR Excel Misc 2 04-13-2006 09:44 PM
How to allow multiple selection capability in excel drop down lis. WritingAcademy Excel Misc 1 03-09-2006 12:27 AM


All times are GMT. The time now is 05:42 AM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
Mail Merging Content With High Quality
oleander (04-17-2014, 11:59 PM)

Aargh. What is this?
PeteJ (04-17-2014, 12:10 PM)

Word 2013 Insert Symbol (Not Responding)
tpthrshr (04-17-2014, 02:49 AM)

Can't save a large Word document
Josh (04-17-2014, 01:03 AM)

Remote help?
newman200 (04-13-2014, 12:54 PM)