1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
Private Sub UserForm_Initialize()
Dim i As Long, sNom As String
With ListView1
With .ColumnHeaders
.Clear
.Add , , "Nom", 140 'Nom est le titre de la colonne A
.Add , , "Parenté", 50 'Parenté est le titre de la colonne C
End With
.View = lvwReport
.FullRowSelect = True
.Gridlines = True
' J 'effectue le tri Feuille BD en suppossant qu'il y a des entetes
Sheets("BD").Select
i = Sheets("BD").Range("A65536").End(xlUp).Row
Sheets("BD").Range("A1:E" & i).Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Sheets("BD").Cells(1, 1).Select
sNom = ""
For i = 1 To Sheets("BD").Range("A65536").End(xlUp).Row
'Si le nom precedent est different on l'ajoute
If Sheets("BD").Cells(i, 1) <> sNom Then
.ListItems.Add , , Sheets("BD").Cells(i, 1)
.ListItems(.ListItems.Count).ListSubItems.Add , , Sheets("BD").Cells(i, 3)
sNom = Sheets("BD").Cells(i, 1)
End If
Next
ListView1.ListItems(1).Selected = False
Set ListView1.SelectedItem = Nothing
End With
End Sub |
Partager