如题所述
转换成ASCII就可以判断了
Dim iA As Integer
iA = Asc(Range("a1").Value)
If (iA >= 65 And iA <= 90) Or (iA >= 97 And iA <= 122) Then
MsgBox "是英文字符"
Else
MsgBox "不是英文字符"
End If
Dim iA As Integer
iA = Asc(Range("a1").Value)
If (iA >= 65 And iA <= 90) Or (iA >= 97 And iA <= 122) Then
MsgBox "是英文字符"
Else
MsgBox "不是英文字符"
End If
温馨提示:答案为网友推荐,仅供参考