How do I allow a multiple selection from a dropdown?

Discussion in 'Excel Misc' started by Monica, Aug 7, 2007.

  1. Monica

    Monica Guest

    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?
     
    Monica, Aug 7, 2007
    #1
    1. Advertising

  2. 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
    news:D...
    > 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, Aug 7, 2007
    #2
    1. Advertising

  3. 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?
     
    challa prabhu, Aug 7, 2007
    #3
  4. Monica

    Monica Guest

    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
    > news:D...
    > > 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?

    >
    >
    >
     
    Monica, Aug 7, 2007
    #4
  5. Monica

    Gord Dibben Guest

    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
    >> news:D...
    >> > 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?

    >>
    >>
    >>
     
    Gord Dibben, Aug 7, 2007
    #5
  6. Monica

    Monica Guest

    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
    > >> news:D...
    > >> > 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?
    > >>
    > >>
    > >>

    >
    >
     
    Monica, Aug 8, 2007
    #6
  7. Monica

    Gord Dibben Guest

    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
    >> >> news:D...
    >> >> > 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?
    >> >>
    >> >>
    >> >>

    >>
    >>
     
    Gord Dibben, Aug 8, 2007
    #7
  8. Monica

    blad3runn69 Guest

    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
     
    blad3runn69, Apr 17, 2008
    #8
  9. Monica

    blad3runn69 Guest

    doh

    ah ok you needd to use forms :)
     
    blad3runn69, Apr 17, 2008
    #9
  10. Monica

    blad3 runn69 Guest

    forms?

    are forms the best way to go? thanks
     
    blad3 runn69, Apr 17, 2008
    #10
  11. Re: 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
     
    Dave Peterson, Apr 17, 2008
    #11
  12. Monica

    Gord Dibben Guest

    Re: 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
     
    Gord Dibben, Apr 17, 2008
    #12
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gailc

    Dropdown selection to autopopulate 2nd dropdown

    Gailc, Apr 26, 2005, in forum: Infopath Newsgroup
    Replies:
    3
    Views:
    101
    Gailc
    May 2, 2005
  2. SteveNic
    Replies:
    1
    Views:
    107
    S.Y.M. Wong-A-Ton
    Aug 5, 2007
  3. Nancy @ CHR
    Replies:
    2
    Views:
    51
    Debra Dalgleish
    Apr 13, 2006
  4. Not Excelerated

    Protection - Allow Dropdown Selection

    Not Excelerated, May 14, 2008, in forum: Excel Misc
    Replies:
    2
    Views:
    32
    Not Excelerated
    May 14, 2008
  5. Denny
    Replies:
    1
    Views:
    55
    OssieMac
    Mar 24, 2010
Loading...

Share This Page