Private Sub ComboBox1_GotFocus()
Dim i&, Dico As Object, TData As Variant
Set Dico = CreateObject("scripting.dictionary")
With Sheets("Feuil4")
TData = .Range(.Cells(2, 1), .Cells(.Rows.Count, 1).End(3))
End With
For i = LBound(TData, 1) To UBound(TData, 1)
Dico(TData(i, 1)) = ""
Next i
ComboBox1.List = Dico.Keys
End Sub