|
各位老师好,有二组VBA代码,想整合在一起,可是不会做,怎样做?
代码1:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim a
If Target.Row <> 2 Then
Exit Sub
Else
a = Target.Column
Sheets("汇总").Cells(a - 7, 5) = Target
End If
End Sub
代码2:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 3 Or Target.Column <> 5 Or Target.Count > 1 Then Exit Sub
Application.EnableEvents = False
If Len(Target) = 0 Then Target.EntireRow = ""
arr = Sheet8.[a1].CurrentRegion
Set d = CreateObject("scripting.dictionary")
For i = 2 To UBound(arr)
d(CStr(arr(i, 1))) = i
Next
i = d(CStr(Target.Value))
If i > 0 Then
Target.Offset(, 1) = arr(i, 4)
Target.Offset(, 2) = arr(i, 9)
End If
Application.EnableEvents = True
End Sub
本帖最后由 france723 于 2017-5-12 15:08 编辑
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim a
- If Target.Row <> 2 Then
- If Target.Row < 3 Or Target.Column <> 5 Or Target.Count > 1 Then
- Exit Sub
- Else
- Application.EnableEvents = False
- If Len(Target) = 0 Then Target.EntireRow = ""
- arr = Sheet8.[a1].CurrentRegion
- Set d = CreateObject("scripting.dictionary")
- For i = 2 To UBound(arr)
- d(CStr(arr(i, 1))) = i
- Next
- i = d(CStr(Target.Value))
- If i > 0 Then
- Target.Offset(, 1) = arr(i, 4)
- Target.Offset(, 2) = arr(i, 9)
- End If
- Application.EnableEvents = True
- End If
- Else
- a = Target.Column
- Sheets("01").Cells(a - 7, 5) = Target
- End If
- End Sub
复制代码
|
|