Option Explicit
Dim LastValue As Variant
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.Intersect(Target, Columns('J')) Is Nothing Then Exit Sub
LastValue = ActiveCell.Offset(0, -7)
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MaPenMemoire() As Date
With Target
If .Column = 10 And .Row > 2 And .Row < 13 Then
ReDim Preserve MaPenMemoire(9)
If Not .Value = Empty Then
Range('C' & .Row) = LastValue + .Value
MaPenMemoire(.Row - 3) = .Value
Else
Range('C' & .Row) = LastValue - MaPenMemoire(.Row - 3)
End If
End If
End With
End Sub