1,451
社区成员
发帖
与我相关
我的任务
分享
Public Sub TXT_change(TXTB As TextBox)
Dim TXT As String
TXT = TXTB.Text
If TXT <> "" Then
Dim Str As String
Str = Right(TXT, 1)
If Not (StrComp(Str, "0") <> -1 And StrComp("9", Str) <> -1) Then '输入的字符在1-9之外
If Not (StrComp(Str, "A") <> -1 And StrComp("Z", Str) <> -1) Then '输入的字符在A-Z之外
If Not (StrComp(Str, "a") <> -1 And StrComp("z", Str) <> -1) Then '输入的字符在a-z之外
MsgBox "对不起,您不能输入非法字符,请您重新输入!", vbOKOnly + vbExclamation, "温馨提示"
Clipboard.SetText Left(TXTB, Len(TXT) - 1)
TXTB = ""
TXTB.SelText = Clipboard.GetText
End If
End If
End If
End If
End Sub