1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Private Sub ApercuBase()
Dim i As Integer
tablo1 = Range("A2:af" & Range("A65536").End(xlUp).Row)
'constitution du tableau la liste d'index Clients
For i = 2 To UBound(tablo1) + 1
ReDim Preserve tablo2(7, i)
tablo2(0, i - 2) = CStr(Cells(i, 1).Value)
tablo2(1, i - 2) = CStr(Cells(i, 7).Value)
tablo2(2, i - 2) = CStr(Cells(i, 8).Value)
tablo2(3, i - 2) = CStr(Cells(i, 9).Value)
tablo2(4, i - 2) = CStr(Cells(i, 11).Value)
tablo2(5, i - 2) = CStr(Cells(i, 12).Value)
tablo2(6, i - 2) = CStr(Cells(i, 18).Value)
tablo2(7, i - 2) = CStr(Cells(i, 17).Value)
Next i
With Me.ListBox1
.ColumnCount = 8
.ColumnWidths = "165;70;90;90;105;40;60;60"
.Column() = tablo2
End With
End Sub |
Partager