Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Set r = [B5,B7,B9,B11]
Set Target = Intersect(Target, r)
If Target Is Nothing Then Exit Sub
Set Target = Intersect(Target(2).Resize(Rows.Count - Target.Row), r)
If Target Is Nothing Then Exit Sub
Application.EnableEvents = False 'désactive les évènements
Target = ""
Application.EnableEvents = True 'réactive les évènements
End Sub