+ Reply to Thread
Results 1 to 5 of 5

Userform with Dropdown list and the ability to select more than one

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    dallas, tx
    MS-Off Ver
    365
    Posts
    51

    Userform with Dropdown list and the ability to select more than one

    I am so close to wrapping up my project, but am stumped on one field on my userform. I had originally created a combobox with a list of choices and now realize the user needs to be able to select more than one choice. I read where a listbox is the better choice, so I created the listbox instead and on the Properties menu selected "multi select." While this does work, I don't want the list to be visible with the choices highlighted in blue. In other words, I want the field to be one line and when it's clicked on it will then show the list to where the user can select more than one item. The results should be displayed separated by a comma, such as, "Physical, Dementia." The value of that field can go into the worksheet as-is with the commas. I don't need it separated out.

    Thanks for any input!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform with Dropdown list and the ability to select more than one

    You can't make multiple selections in a combobox so you would need code that would somehow 'save' the item the user picks each time they select from the combobox.

    Few ways I can think of doing that, a dynamic array to store the user's choices, write them to a (hidden) textbox on the userform or even write them directly to a cell.

    Not sure which of those, if any, would be appropriate.
    If posting code please use code tags, see here.

  3. #3
    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
    44,137

    Re: Userform with Dropdown list and the ability to select more than one

    Is this what you had in mind, or at least a workaround???
    Attached Files Attached Files
    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

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Userform with Dropdown list and the ability to select more than one

    Oops, didn't realise you might not be using a userform.

  5. #5
    Registered User
    Join Date
    07-29-2016
    Location
    dallas, tx
    MS-Off Ver
    365
    Posts
    51
    Quote Originally Posted by Norie View Post
    Oops, didn't realise you might not be using a userform.
    Yes, I am using a UserForm. The listbox keeps the list expanded, and the choices highlighted. I just don't know if there's a code to accomplish what I'm wanting.

+ 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. Replies: 5
    Last Post: 04-23-2016, 11:34 AM
  2. Dropdown list to select data
    By Booswig in forum Excel General
    Replies: 9
    Last Post: 04-15-2015, 06:34 AM
  3. Userform Combobox - select from list, store this as default each time userform loads
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2014, 07:48 AM
  4. Select Picture via Dropdown list
    By cmlucifer in forum Excel General
    Replies: 6
    Last Post: 01-21-2014, 02:51 PM
  5. Replies: 4
    Last Post: 09-10-2013, 02:11 PM
  6. Userform vlookup with the ability to save or select values
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-06-2009, 12:16 PM
  7. How to select different Macros from a dropdown list?
    By globulous in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2007, 12:16 AM

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