+ Reply to Thread
Results 1 to 6 of 6

Drop Down List: Multiple Choices Selected

  1. #1
    Registered User
    Join Date
    04-08-2010
    Location
    Mountain ash
    MS-Off Ver
    Excel 2010
    Posts
    13

    Drop Down List: Multiple Choices Selected

    Hi,

    I have a drop down list that I would like to choose multiple items from, I believe that I will need a VBA code for this? The sheet contains multiple drop down list, but I only want one of these list to have the multiple choice option - is this possible?

    cheers

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Drop Down List: Multiple Choices Selected

    You will need VBA to do that. However you also need to explain in detail what you want PARTICULARLY explaining he output you expect to see. Also, attaching a sheet helps (minus confidential information...).

    Go Advanced / Manage Attachments and its easy to attach a file.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    04-08-2010
    Location
    Mountain ash
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Drop Down List: Multiple Choices Selected

    Hi, Attached is the spreadsheet, on the tab 'Summary' I have a number of columns that contain drop down lists, however under column AC I have a drop down list that I wish to be multiple choice, all other drop down you should only be able to select one option.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Drop Down List: Multiple Choices Selected

    Try this out:

    Please Login or Register  to view this content.
    as in the attached sheet.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-08-2010
    Location
    Mountain ash
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Drop Down List: Multiple Choices Selected

    that's absolutely brilliant - thank you very much......

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Drop Down List: Multiple Choices Selected

    Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dependent Drop Down list to autofill next drop down with selective choices
    By MitchellHydro1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2015, 01:18 PM
  2. Replies: 8
    Last Post: 10-29-2014, 06:17 AM
  3. How to create a drop down list based on the choices of another drop down list?
    By Happy jain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2013, 01:54 AM
  4. Replies: 0
    Last Post: 04-15-2013, 09:22 AM
  5. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  6. Multiple choices in a drop-down list
    By Heidipup in forum Excel General
    Replies: 3
    Last Post: 01-16-2007, 03:33 AM
  7. Drop down list with multiple choices
    By Cindy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2005, 09:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1