Private Sub Worksheet_Change(ByVal Target As Range)
'si modif de la colonne G
If Target.Column = 7 Then
If (Target = "x" Or Target = "X") And (Target.Offset(0, 1) = "a" Or Target.Offset(0, 1) = "A" Or Target.Offset(0, 1) = "r" Or Target.Offset(0, 1) = "R" Or Target.Offset(0, 1) = "p" Or Target.Offset(0, 1) = "P") Then
Target.Offset(0, 6) = Time
End If
'si modif de la colonne H
ElseIf Target.Column = 8 Then
If (Target.Offset(0, -1) = "x" Or Target.Offset(0, -1) = "X") And (Target = "a" Or Target = "A" Or Target = "r" Or Target = "R" Or Target = "p" Or Target = "P") Then
Target.Offset(0, 5) = Time
End If
End If
End Sub