Private Sub ComboBox1_Change()
Dim i As Integer
Dim Item As Variant
If flag = 1 Then flag = 0: Exit Sub
listview.ListView1.ListItems.Clear
Set f = Sheets("Grille_de_Dispensation")
a = Range(f.[A2], f.[A65000].End(xlUp))
For i = LBound(a) To UBound(a)
If a(i, 1) = ComboBox1 Then
listview.ComboBox1.AddItem Cells(i + 1, 1)
Set Item = listview.ListView1.ListItems.Add(Text:=Sheets("Grille_de_Dispensation").Cells(i + 1, 1))
Item.SubItems(1) = Format(Sheets("Grille_de_Dispensation").Cells(i + 1, 2), "mmm-yyyy")
Item.SubItems(2) = Sheets("Grille_de_Dispensation").Cells(i + 1, 3)
Item.SubItems(3) = Sheets("Grille_de_Dispensation").Cells(i + 1, 4)
Item.SubItems(4) = Sheets("Grille_de_Dispensation").Cells(i + 1, 5)
Item.SubItems(5) = Sheets("Grille_de_Dispensation").Cells(i + 1, 6)
Item.SubItems(6) = Sheets("Grille_de_Dispensation").Cells(i + 1, 7)
Item.SubItems(7) = Sheets("Grille_de_Dispensation").Cells(i + 1, 8)
Item.SubItems(8) = Sheets("Grille_de_Dispensation").Cells(i + 1, 9)
Item.SubItems(9) = Format(Sheets("Grille_de_Dispensation").Cells(i + 1, 10), "mmm-yyyy")
Item.SubItems(10) = i + 1
End If
Next i