+ Reply to Thread
Results 1 to 3 of 3

Data Validation Multiple Selection - Keep Dropdown Box Open to Make Selections

  1. 05-31-2016, 08:16 AM #1
    PSSMargaret is offline
    Registered User
    Join Date
    04-29-2016
    Location
    Ocean Isle Beach, NC
    MS-Off Ver
    2010
    Posts
    54

    Data Validation Multiple Selection - Keep Dropdown Box Open to Make Selections

    My spreadsheet contains a column with data validation that I have inserted code (below) that will allow multiple selections. Is there additional code that will allow the drop down list to stay open while selecting the multiple selections. Currently, I have to select one and then go back and click the drop down arrow again in order make another selection. It would be ideal if the list would stay open during the multiple selections.

    Any assistance is appreciated.

    Margaret

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-31-2016, 09:57 AM #2
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Data Validation Multiple Selection - Keep Dropdown Box Open to Make Selections

    Probably not possible without using some sort of userform. A quick search throws up a few possibilities, including these:
    http://www.excel-easy.com/vba/exampl...elections.html
    http://www.contextures.com/excel-dat...n-listbox.html
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
  3. 05-31-2016, 12:32 PM #3
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Data Validation Multiple Selection - Keep Dropdown Box Open to Make Selections

    I don't know of a method to have the DV list dropdown remain visible. An alternative to using a DV dropdown list is to use a pop-up multi-selection listbox. The listbox could be positioned just below the cell to look very similar to a DV dropdown list.
    • Does your sheet have just one or multiple DV lists now?
    • What cells have the lists?
    • How are the DV lists populated; comma separated values or a Range? Please describe.
    • Do they all use the same list; if not please explain.
    Last edited by AlphaFrog; 05-31-2016 at 12:43 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple selections using data validation (sumifs)
    By scruz9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2015, 04:10 PM
  2. Multiple selections from data validation list
    By astasinim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2015, 11:20 AM
  3. omit menu items via data validation for multiple selections and multiple menus when select
    By themattyp503 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2014, 12:16 AM
  4. Filter Multiple Selections Data Validation
    By yisfromer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2013, 12:23 PM
  5. Multiple selections from data validation macro
    By strud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 05:09 AM
  6. How to make a dropdown option dependent on a previous dropdown selection??
    By Bill Williams in forum Excel General
    Replies: 2
    Last Post: 08-11-2011, 01:32 AM
  7. How can I allow users to make multiple selections from a dropdown.
    By Liz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2005, 05:15 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1