Results 1 to 6 of 6

Thread: Excel 2010 Multi select drop down menus

  1. #1

    Excel 2010 Multi select drop down menus



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm not sure what category this question falls into...
    I have created multiselect drop down menus in a spreadsheet.
    I want to know how I can extract the users choices into another cell in the spreadsheet.
    Any help would be appreciated

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    You simply create a formula that references them.

    e.g. If dropdown is in A1, then formula is =A1 if you are in another sheet, then ='Sheet1'!A1 where Sheet1 is name of sheet where drop down is.


  3. #3

    Multiselect

    NBVC
    Thanks for your reply. What you suggested works when the user can only select one item in the drop down. When the user has the option to select more than one, is where I'm stuck.

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Where are you sending the selected items?


  5. #5

    multisellect

    NBVC
    That's part of the mystery. When you use a ListBox as opposed to a conventional drop down menu, I have no idea where the data is stored.

    Developer->Controls->Insert->Form Controls->List Box

    The list box is not tied to a cell. It sort of sits where ever you like "above" the cells.

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Duplicate thread.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •