Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)If Target.Column = 1 ThenTarget.Value = DateCancel = TrueElseIf Target.Column = 2 ThenTarget.Value = TimeCancel = TrueEnd IfEnd Sub