我有代码,每当在B列中输入内容时,该代码就会在A列中显示日期。
我在安全设置中启用了宏。
VBA代码位于项目下的ThisWorkbook
中,因为我希望每张纸上都发生相同的事情。
Private Sub Workbook_SheetChange(ByVal Sh As Object,_
ByVal Source As Range)
Dim WorkRng As Range
Dim Rng As Range
Dim xOffsetColumn As Integer
Set WorkRng = Intersect(Application.activeSheet.Range("B:B"),Target)
xOffsetColumn = -1
If Not WorkRng Is Nothing Then
Application.EnableEvents = False
For Each Rng In WorkRng
If Not VBA.IsEmpty(Rng.Value) Then
Rng.Offset(0,xOffsetColumn).Value = Now
Rng.Offset(0,xOffsetColumn).NumberFormat = "dd-mm-yyyy,hh:mm:ss"
Else
Rng.Offset(0,xOffsetColumn).ClearContents
End If
Next
Application.EnableEvents = True
End If
End Sub