Hi Guys,
I have some code to return the values from a multiselect list box when writing the data from a userform to my worksheet. I thought it was working, but have just realised that it is not...
I have 3 list boxes on my userform, and 3 columns that the data is to be written to.
- List box one writes to the designated column (correct)
- List box 2 writes the data from list box 1 & 2 to the designated column (I only want the data from the 2nd list box!)
- List box 3 writes the data from all 3 list boxes into the column! (I only want the data from the 3rd list box!)
I don't know how to fix it! I'm assuming I need to 'clear' it between? Code below. Please help!
Bookmarks