Good morning/afternoon,
I have a listbox which allows a user to select multiple values. This popluates the workbook's active cell. For times when 10 items of a list of 500 may be selected, I don't want to have an editor of that cell to have to reselect almost all preselected values if they're only looking to remove one of the 10.
How can I have the listbox open up with the activecell's values pre-selected? I've tried several solutions, none of which was I able to adapt. I'm not saying they're not adaptable. The problem lies with my skill.
The code to populate the active cell is below. How can I reverse this to return the values to the listbox when it opens?
Bookmarks