Private Sub Worksheet_Change(ByVal Target As Range)
If InStr(Range("F7"), "决赛") Then
Application.EnableEvents = False
Range("I7").ClearContents
Application.EnableEvents = True
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If InStr(Range("F7"), "决赛") Then
Application.EnableEvents = False
Range("I7").ClearContents
Application.EnableEvents = True
End If
End Sub