I'm having trouble moving multiple columns from one list box to another. ListBox1 is populated with 4 columns from a spread sheet and ListBox 2 is empty. I want users to be able to press the "add button" which will firstly add the item to ListBox 2 and also remove it from ListBox1 so they can no longer choose it. Furthermore, I would like the "remove button" to do the reverse and add the item from ListBox2 back to ListBox 1 whilst deleting it from ListBox2. This is all being done in Excel VBA userform
Solved by T. S. in 20 mins