I have an Excel 2007 userform with two listboxes
Listbox1 is a 5column, multiselect listbox
Listbox2 is a 5 column, single select listbox

What's the best way to loop through listbox1 and copy all the selected items into listbox2?
All 5 columns need to be copied.

Any assistnace would be much appreciated.

Thanks