ListBox column data transfer to another ListBox

[gsandy]

I have a form with two ListBoxes (ListBox1 & ListBox2). The code to initialize ListBox1 is below, where a named range (SheetA) in entered into cell A1:

Please Login or Register  to view this content.

There is a CommandButton to move selection from ListBox1 to ListBox2, code below:

Please Login or Register  to view this content.

The first code works fine and generates a 3 column list. But the second code only transfers the first column into ListBox2. How can the code be altered to transfer all 3 columns from ListBox1 to ListBox2? Thanks Sandy

[Norie]

Try this.

Please Login or Register  to view this content.

[gsandy]

Thanks Norie that worked.
Would you help with code to shift selected items in ListBox2 back to ListBox1? Currently I have:

Please Login or Register  to view this content.

[gsandy]

Hi Norie I got the code to work. Thanks for giving me the clues!