Private Sub Worksheet_Change(ByVal Target As Range)
Dim tablo, i&, x$, a(), n&
With Sheets("Liste")
If .FilterMode Then .ShowAllData 'si la feuille est filtrée
tablo = .Range("A1:B" & .Range("A" & .Rows.Count).End(xlUp).Row) 'matrice, plus rapide, au moins 2 éléments
End With
For i = 2 To UBound(tablo)
x = CStr(tablo(i, 1))
If x <> "" Then
ReDim Preserve a(n) 'base 0
a(n) = x
n = n + 1
End If
Next
With Sheets("Coordos").ComboBox1
.ListFillRange = "" 'sécurité
If n Then .List = a Else .Clear
End With
End Sub