Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim P As Range, source As Range
Set P = Range("E9:E" & Rows.Count)
P.Validation.Delete 'RAZ
If Intersect(ActiveCell, P) Is Nothing Then Exit Sub
Set source = Sheets("Feuil1").[A7].CurrentRegion
With Sheets("Liste")
.Columns(1).Clear 'RAZ
If ActiveCell = "" Then Exit Sub
source.AutoFilter 3, ActiveCell & "*" 'filtre automatique
source.Columns(3).Copy .[A1]
source.AutoFilter 3
.[A1].Delete xlUp
If .[A1] <> "" Then ActiveCell.Validation.Add xlValidateList, Formula1:="=" & .Name & "!" & .UsedRange.Columns(1).Address
End With
End Sub