|
在工作表sheet1的change写代码:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <= 3 Then
s1 = Cells(Target.Row, 1)
s2 = Cells(Target.Row, 2)
s3 = Cells(Target.Row, 3)
bz = False
For i = 1 To Sheet2.[e10000].End(3).Row
If (Sheet2.Cells(i, 5) = s1) And (Sheet2.Cells(i, 6) = s2) And (Sheet2.Cells(i, 7) = s3) Then
s4 = Sheet2.Cells(i, 8)
s5 = Sheet2.Cells(i, 9)
Cells(Target.Row, 4) = s4
Cells(Target.Row, 5) = s5
bz = True
Exit For
End If
Next i
If Not bz Then
Cells(Target.Row, 4) = ""
Cells(Target.Row, 5) = ""
End If
End If
End Sub
|
评分
-
查看全部评分
|