Bonjour Antho,
En PJ un essai.
VB:Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) With Target If .Column = 7 Then Cancel = True Cells(.Row, .Column + 1) = 1 + Cells(.Row, .Column + 1) End If End With End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target
If .Column = 7 Then
Cancel = True
Cells(.Row, .Column + 1) = 1 + Cells(.Row, .Column + 1)
End If
End With
If Not Application.Intersect(Target, Range("B:B")) Is Nothing And IsEmpty(Target) Then
F_calendrier1dateTableur.Show
End If
Cancel = True
If Target.Column = 8 Then
Cells(Target.Row, 8) = Date
Cells(Target.Row, 6).Interior.color = vbYellow ' jaune
End If
If Target.Column = 11 Then
Cells(Target.Row, 11) = Date
Cells(Target.Row, 10).Interior.color = vbGreen ' Vert
End If
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Application.Intersect(Target, Range("G:G")) Is Nothing Then
If IsNumeric(Mid(Target.Value, Len(Target.Value), 1)) Then
Target.Value = Mid(Target.Value, 1, Len(Target.Value) - 1) & Mid(Target.Value, Len(Target.Value), 1) + 1
Else
Target.Value = Target.Value & 1
End If
End If
If Not Application.Intersect(Target, Range("B:B")) Is Nothing And IsEmpty(Target) Then
F_calendrier1dateTableur.Show
End If