Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2007
    Location
    Sacramento, California, USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it possible to create a list that more than one item can be chosen from?

    for example a list of 10 activites and someone could choose up to 5 activities from the same list.

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I think you might need to expand on where this list is.

    Is this a Listbox on a sheet, a Listbox on a Userform?
    Both of these have a mutli select property

    But what should happen to them after that?

    You cannot do it with a Data Validation list
    Andrew

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Will the attached file do what you want.
    All but B2:F2 is protected to prevent your users from entering data in the wrong places.
    There is no password so, you can just remove the protection.

    [attachment=88682:Choosing.xls]
    Attached Files Attached Files

Posting Permissions

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