Private Sub Worksheet_Change(ByVal Target As Range)
Dim r, c
r = Target.Row
c = Target.Column
'如果发生值改变的区域,行号大于1,且不是G列就是H列。
If r > 1 And (c = 7 Or c = 8) Then
'如果该区域所对应的B列的值大于0,且C列等于0
If Cells(r, "b") > 0 And Cells(r, "c") = 0 Then
MsgBox "停止呀!"
Application.EnableEvents = False
Target = ""
Application.EnableEvents = True
End If
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim r, c
r = Target.Row
c = Target.Column
'如果发生值改变的区域,行号大于1,且不是G列就是H列。
If r > 1 And (c = 7 Or c = 8) Then
'如果该区域所对应的B列的值大于0,且C列等于0
If Cells(r, "b") > 0 And Cells(r, "c") = 0 Then
MsgBox "停止呀!"
Application.EnableEvents = False
Target = ""
Application.EnableEvents = True
End If
End If
End Sub