Put selected names in correct place
How do I modify this code to place the selected names from a MultiSelect
listbox starting in cell A73 not A1?
Sub DropButton_Click()
Dim i As Long, j As Long
For i = 0 To TeamListBox.ListCount - 1
If TeamListBox.Selected(i) Then
j = j + 1
Cells(j, "A").Value = TeamListBox.List(i)
End If
Next
Thanks
--
Jim T
|