Private Sub UserForm_Initialize()
ListBox1.RowSource = "A1:A" & Cells(65536, 1).End(xlUp).Row
ListBox1.ListStyle = fmListStyleOption
ListBox1.MultiSelect = fmMultiSelectMulti
End Sub
'
Private Sub CommandButton1_Click()
ListBox2.Clear
For i = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(i) = True Then
ListBox2.AddItem ListBox1.List(i)
End If
Next
End Sub
Hiç yorum yok:
Yorum Gönder