Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
'录入林场发文时间
If Target.Offset(0, 1) <> "" Then Exit Sub
If Target.Column = 2 And Target <> "" Then
Target.Offset(0, 1) = VBA.Date
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
'录入发文企划时间
'On Error Resume Next
'If Target.Offset(0, -1) <> "" Then Exit Sub
'If Target.Column = 8 And Target <> "" Then
'Target.Offset(0, -1) = VBA.Date
'End If
'End Sub
if Target.Offset(0, -1) <> "" or Target.Offset(0, 1) <> "" Then Exit Sub
If Target.Column = 2 And Target <> "" Then
Target.Offset(0, 1) = VBA.Date
elseif Target.Column = 8 And Target <> "" then
'Target.Offset(0, -1) = VBA.Date
End If
点击文件名下载附件
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
'如果改动的是第二列并且第三列为空值,那么第三列显示日期
If Target.Column = 2 And Target <> "" And Target.Offset(0, 1) = "" Then
Target.Offset(0, 1) = VBA.Date
End If
'如果改动的是第8列或第11列或第14列或第17列,并且前一列为空值,那么前一列显示日期
If (Target.Column = 8 Or Target.Column = 11 Or Target.Column = 14 Or Target.Column = 17) And Target <> "" And Target.Offset(0, -1) = "" Then
Target.Offset(0, -1) = VBA.Date
End If
End Sub