Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then ... [COLOR="Blue"]'effacer ...[/COLOR]
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 2 Then Target.Offset(0, -1).Clear
If Target.Column = 1 Then Target.Offset(0, 1).Clear
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Temp1
Dim Temp2
If Target.Column > 1 Then Temp1 = Target.Offset(0, -1)
If Target.Column < 256 Then Temp2 = Target.Offset(0, 1)
If Target.Column = 2 Then Target = Temp1: Target.Offset(0, -1).Clear
If Target.Column = 1 Then Target = Temp2: Target.Offset(0, 1).Clear
End Sub