Private Sub Worksheet_Change(ByVal Target As Range)
Dim plage As Range
If Target.Count > 1 Then Exit Sub
If Intersect(Target, Columns('c')) Is Nothing Then Exit Sub
With Sheets('feuil1')
Set place = .Range('c6:c' & .Range('c65536').End(xlUp).Row).Find(Target)
If Not place Is Nothing Then
MsgBox 'Pas bon.'
Target.Select
Application.EnableEvents = False
Target.Clear
Application.EnableEvents = True
End If
End With
End Sub