Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Selecting multiple values from dropdown list

    Hi,

    Does anyone know how I can create a dropdown list that will allow me to select multiple values in the same cell. Any help would be great!

    Thank you.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Does this do what you want?

    Steve
    Last edited by sdckapr; 2011-02-14 at 18:15. Reason: removed attachment. New version in later post

  3. #3
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Hi Steve,

    Great example but I need it as a dropdown list within the cell. For example, on A1, I need a dropdown list that I select multiple people and will show in A1 as (Mary, John, Lisa etc) Any ideas?

    Thank you in advance!

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How about this. I added a graphic that runs code to toggle the listbox from visible to not visible. When visible you can select it to add/remove things from A1.

    Steve
    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
  •