Private Sub UserForm_Initialize()
Dim fin&, i&, j&
fin = Worksheets("toto").Range("B" & Rows.Count).End(xlUp).Row
With ListView1
'entêtes de colonnes
With .ColumnHeaders
.Add , , "Essai", 100
.Add , , "Nom", 100
.Add , , "Prénom", 100
End With
For i = 3 To fin
'élément de tête en colonne 2 (B)
.ListItems.Add , , Worksheets("toto").Cells(i, 2).Value
'sous éléments à partir de la colonne 3 (C)
For j = 3 To 4
.ListItems(.ListItems.Count).ListSubItems.Add , , Worksheets("toto").Cells(i, j).Value
Next j
Next i
End With
ListView1.View = 3
ListView1.Gridlines = True
ListView1.AllowColumnReorder = True
ListView1.FullRowSelect = True
End Sub