Private Sub TextBox1_Change()
If Not IsNumeric(TextBox1.Value) And TextBox1.Value <> "" Then
Application.EnableEvents = False
MsgBox "你必须输入数字!"
TextBox1 = ""
Application.EnableEvents = True
End If
End Sub
Private Sub TextBox1_Change()
If Not IsNumeric(TextBox1.Value) And TextBox1.Value <> "" Then
Application.EnableEvents = False
MsgBox "你必须输入数字!"
TextBox1 = ""
Application.EnableEvents = True
End If
End Sub