When attempting to move multiple selected items from one multi-column list box to another with the code below, I get the Compile error: Method or data member not found. It appears to fail on the line that reads Me.ListBox2.AddItem Me.ListBox1.List(i). Thanks in advance for help on this one.
Private Sub CmdMoveItems_Click()
Dim i As Long
For i = 0 To Me.ListBox1.ListCount - 1
If Me.ListBox1.Selected(i) = True Then
Me.ListBox2.AddItem Me.ListBox1.List(i)
End If
Next i
For i = Me.ListBox1.ListCount - 1 To 0 Step -1
If Me.ListBox1.Selected(i) = True Then
Me.ListBox1.RemoveItem i
End If
Next i
End Sub