Private Sub Worksheet_Change(ByVal Target As Range)
Dim Col As Long
Col = 0
If Target.Count > 1 Then Exit Sub
If Target.Column = 3 Then
If Target.Value = "dépenses" Then
Col = 4
ElseIf Target.Value = "recettes" Then
Col = 5
End If
Target.Offset(0, Col).Select
End If
End Sub