There is a thread from 2007 with the same question (here) but I am having trouble making the code work. There is a help file attached with the bits of code I already have.
I am an absolute beginner and need this to help automate a bureaucratic mess at work, all help would be much appreciated!
So I have a multiselect listbox that is displayed when a cell is double clicked. It is great for data input, but not so much for editing.
I would like to have the contents from the Active cell (the one that is double clicked) to be selected in the listbox when it is loaded to make editing easier (some cells will have 70+ selections and it will be super annoying to have to select everything from scratch just to add or take off one of the selections).
Sheet1 has the code that loads the user form upon doubleclicking.
Multiselect Listbox is populated by a dynamic range DynOptions (made using offset and counta).
I am missing the bit that turns the active cell content into listbox selection.
Could anyone help?
Thank you so much!