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

[PSSMargaret]

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.

[Aardigspook]

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

[AlphaFrog]

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.