Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
ListBox1.Clear
If Target.Address(0, 0) = 'F16' Then
With Sheets('Feuil1')
For Each c In .Range('k2:k' & .Range('k65536').End(xlUp).Row)
If c = Target Then ListBox1.AddItem c.Offset(0, -9)
Next c
End With
End If
End Sub