|
本帖最后由 l00l00 于 2012-5-29 07:17 编辑
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target = "" Or Target.Count > 1 Then Exit Sub
Select Case Target.Column
Case 2
If Target.Offset(0, 1) = "" Then Target.Offset(0, 1) = VBA.Date
Case 8, 11, 14, 17
If Target.Offset(0, -1) = "" Then Target.Offset(0, -1) = VBA.Date
End Select
End Sub |
|