Extracting values from multiselect list box

[Kite3]

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!

Please Login or Register  to view this content.

[millz]

Add these lines:

Please Login or Register  to view this content.

[Kite3]

Excellent, thanks millz, working now