Excel如何用VBA来实现在 D列 自动输入当前时间

Option ExplicitPrivate Sub Worksheet_Change(ByVal Target As Range) Dim i As Long i = Target.Row If i > 3 And Target.Column = 11 Then Columns("D:D").NumberFormatLocal = "yyyy/m/d h:mm;@" If Cells(i, 3)