Private Sub Worksheet_Change(ByVal Target As Range)
' Macro permettant le calcul de la pénalité mixité
If Target.Column <> 7 Then Exit Sub
If Target.Row < 3 Then Exit Sub
' Cstr pour faire la difference entre 0 et rien
Select Case CStr(Cells(Target.Row, 7).Value)
Case Is = "0"
Cells(Target.Row, 8).Value = "20sec"
Case Is = "1"
Cells(Target.Row, 8).Value = ""
Case Is = "2"
Cells(Target.Row, 8).Value = ""
Case Is = "3"
Cells(Target.Row, 8).Value = ""
Case Is = "4"
Cells(Target.Row, 8).Value = ""
Case Else
Cells(Target.Row, 8).Value = "?"
End Select
End Sub