Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim CelA As Range, L As Long
If Target.Address <> [Douchette].Address Then Exit Sub
Application.EnableEvents = False
Set CelA = Cells(Rows.Count, 1).End(xlUp)
CelA.Value = Target.Value
Select Case CelA.Offset(, 2).Value
Case "A JETER": Call JouerSonLong
Case "OK": Call JouerSonCourt
On Error Resume Next
L = WorksheetFunction.Match(Target.Value, Feuil4.[A4:A14], 0)
If Err = 0 Then Feuil4.[C4].Rows(L).Value = "×"
On Error GoTo 0
End Select
Target.ClearContents ' vider cellule douchette
Target.Select
Application.EnableEvents = True
End Sub