Bonjour,
Bonjour Ric,
Un peu confus !...
Les données sont sous forme de tableau.
Cdlt.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim lo As ListObject, blnCol As Boolean
If Not Target.ListObject Is Nothing And Target.Count = 1 Then
Set lo = Target.ListObject
blnCol = CBool(Target.Column - lo.HeaderRowRange.Column + 1 = 4)
If blnCol And LCase$(Target.Value) = "oui" And IsEmpty(Target.Offset(, -2)) Then
Target.Offset(, -2).Value = VBA.Now()
End If
End If
End Sub