Bonjour Enenoiz, le forum,
Salut m3ellem1,
Une autre contribution....à tester également...
Tu inscris la date en colonne A, l'incrémentation se fait alors en colonne B.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Long, dl As Long, plage As Range
With Sheets("Feuil1")
dl = .Range("A" & Rows.Count).End(xlUp).Row
Set plage = .Range("A2:A" & dl)
If Not Application.Intersect(Target, plage) Is Nothing Then
If Target.Value <> "" Then
Select Case Target.Offset(-1, 1)
Case Is = 149
Target.Offset(, 1) = 150
MsgBox "Changer les outils"
Case Is = 150
Target.Offset(, 1) = 1
Case Else
Target.Offset(, 1) = Target.Offset(-1, 1) + 1
End Select
End If
End If
End With
End Sub
Cordialement,