Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Value = Date
End Sub
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target
If .Column = 3 Or .Column = 18 Then .Value = Date
End With
Cancel = True
End Sub
With Target
If .Column = 3 Or .Column = 18 Then .Value = Date:Cancel = True
End With
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target
If .Column = 3 Or .Column = 18 Then .Value = Date: Cancel = True
End With
End Sub
Si tu saisis Ctrl+";" (la touche Control + le point-virgule), tu auras la date courante dans ta cellule, de même que Ctrl+":" te donneras l'heure courante, et ceci sans VBA ...Qu'entends-tu par CTRL ?