Results 1 to 5 of 5

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.
    I'm hoping this is simple and not a VBA effort.
    Any help would be appreciated

  2. #2
    Acolyte Charles's Avatar
    Join Date
    Feb 2013
    Location
    Biloxi
    Posts
    34
    Articles
    0
    Hi,

    In the cell you want the info to appear you can use "=E1"" as an example.
    E1 will be cell that you have the dropdown.
    This will not work for multi select.
    Are you really using a "DropDown" or "Combobox"?

    Remark
    After thinking about this I think you may need code. And too if the data selected goes to the same cell
    it will need to be joined.
    Last edited by Charles; 2014-04-29 at 09:24 PM. Reason: add info

  3. #3

    Multiselect

    Charles
    I'm using a ListBox.

  4. #4
    Acolyte Charles's Avatar
    Join Date
    Feb 2013
    Location
    Biloxi
    Posts
    34
    Articles
    0
    Hum,

    Then I think you need code.

  5. #5
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    I will let Charles continue this. And I will lock your 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
  •