1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| UserForm2.ListBox1.Clear
UserForm2.ListBox1.ColumnCount = 11
For i = 4 To Range("A65536").End(xlUp).Row
If Not Rows(i - 1).Hidden Then UserForm2.ListBox1.AddItem
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 0) = Feuil1.Cells(i, 1)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 1) = Feuil1.Cells(i, 2)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 2) = Feuil1.Cells(i, 3)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 3) = Feuil1.Cells(i, 4)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 4) = Feuil1.Cells(i, 5)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 5) = Feuil1.Cells(i, 6)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 6) = Feuil1.Cells(i, 7)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 7) = Feuil1.Cells(i, 8)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 8) = Feuil1.Cells(i, 9)
UserForm2.ListBox1.List(UserForm2.ListBox1.ListCount - 1, 9) = Feuil1.Cells(i, 10)
Next i
UserForm2.ListBox1.BoundColumn = 1
UserForm2.ListBox1.ColumnWidths = "20;20;20;20;25;150;150;150;50;50"
UserForm2.Show |
Partager