- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Row > 3 Then
- If Target.Column = 21 Or Target.Column = 22 Then
- If Len(Target) Then
- Dim x%
- x = (Target.Column - 21) * 10 + 1
- Cells(Target.Row, x) = Format(Now, "c")
- Cells(Target.Row - 1, x + 1).AutoFill Destination:=Range(Cells(Target.Row - 1, x + 1), Cells(Target.Row, x + 1))
- Cells(Target.Row, x + 1).AutoFill Destination:=Range(Cells(Target.Row, x + 1), Cells(Target.Row, x + 8))
- End If
- End If
- End If
- End Sub
复制代码
动态显示当前系统时间日期.rar
(23.29 KB, 下载次数: 16)
|