Private Sub UserForm_Initialize()
With Sheets("Donnees")
For i = 2 To .Range("A65000").End(xlUp).Row
If .Cells(i, 1) <> .Cells(i - 1, 1) Then
ComboStade.AddItem .Cells(i, 1).Value
End If
Next
For i = 2 To .Range("B65000").End(xlUp).Row
If .Cells(i, 2) <> .Cells(i - 1, 2) Then
ComboCritere.AddItem .Cells(i, 2).Value
End If
Next
For i = 2 To .Range("C65000").End(xlUp).Row
If .Cells(i, 3) <> .Cells(i - 1, 3) Then
ComboType.AddItem .Cells(i, 3).Value
End If
Next
End With
End Sub