TIGER

Excel内容更新后,自动更新最后修改时间
VBA代码如下: Private Sub Worksheet_Change(ByVal Target As Ra...
扫描右侧二维码阅读全文
21
2016/09

Excel内容更新后,自动更新最后修改时间

VBA代码如下:

Private Sub Worksheet_Change(ByVal Target As Range)
 Range("A1") = "更新日期:" & Now()
End Sub

A1是时间所在位置

Last modification:July 11th, 2018 at 09:45 pm
If you think my article is useful to you, please feel free to appreciate

Leave a Comment