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.
Bookmarks