本帖最后由 ioi_chan 于 2017-5-27 18:39 编辑
C欄的任一格自動互換後,B欄與D欄也一起作相應的位置互換,請問各位老師這個B欄與D欄的VBA要怎樣寫,
再次感謝各位老師的幫助!謝謝!
本帖最后由 france723 于 2017-5-27 18:27 编辑
- Dim Ad
- Dim ada
- Dim adb
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Application.EnableEvents = False
- If Target.Column > 26 Or Target.Count > 10 Then Exit Sub
- Ad = Target
- ada = ActiveCell.Offset(0, -1)
- adb = ActiveCell.Offset(0, 1)
- Application.EnableEvents = True
- End Sub
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Column > 26 Or Target.Count > 10 Then Exit Sub
- Application.EnableEvents = False
- Dim y, ar, i
- y = Range("C65536").End(3).Row
- ar = Range("a1:d" & y)
- For i = 1 To UBound(ar)
- If i <> Target.Row Then
- If Target = ar(i, 3) Then
- Cells(i, 3) = Ad
- Cells(i, 2) = ada
- Cells(i, 4) = adb
- Target.Offset(0, -1) = ar(i, 2)
- Target.Offset(0, 1) = ar(i, 4)
- End If
- End If
- Next i
- Application.EnableEvents = True
- End Sub
复制代码你修改我之前的代码,还是有点小问题,也帮你改过来了。
|