2,462
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim objSheet As Worksheet
Select Case Target.Address
Case "$B$2"
Set objSheet = Sheets(2)
Case "$B$3"
Set objSheet = Sheets(3)
End Select
Dim lngRow As Long
lngRow = 1
While objSheet.Cells(lngRow, 1) <> ""
lngRow = lngRow + 1
Wend
If lngRow > 1 Then
If CDbl(objSheet.Cells(lngRow - 1, 1)) = CDbl(Target) Then
Exit Sub
End If
End If
objSheet.Cells(lngRow, 1) = Target.Value
objSheet.Cells(lngRow, 2) = Now
End Sub