Private Sub Worksheet_Change(ByVal Target As Range)
Dim n%
On Error GoTo 100
***.enableevents = False
If ***.column = 1 And ***.offset(0, 1) _
And ***.isnumber(***.offset(0, 1) * 1) Then
n = MsgBox(用加法请按“回车或Y” & Chr(10) & _
用乘法请按“N”, vbYesNo)
If n = 6 Then
Target = Target + ***.offset(0, 1)
Else
Target = Target * ***.offset(0, 1)
End If
End If
100
***.enableevents = True
End Sub