2,462
社区成员
发帖
与我相关
我的任务
分享
Private Sub worksheet_change(ByVal Target As Range)
Application.EnableEvents = False
If Not Intersect(Target, [H5,X4]) Is Nothing Then
If Target.Address = "$H$5" Then
[X4] = [H5]
Else
[H5] = [X4]
End If
End If
If Not Intersect(Target, [H7,y6]) Is Nothing Then
If Target.Address = "$H$7" Then
[y6] = [H7]
Else
[H7] = [y6]
End If
End If
Application.EnableEvents = True
End Sub