Sub test() '正则 Dim regex As Object set regex = CreateObject("vbscript.regexp") With regex .Global = True .Pattern = "[\u4e00-\u9fa5]" MsgBox .test([a1]) End With End Sub
Sub test2() If [a1].Value Like "[一-龥]" Then MsgBox "汉字" Else MsgBox "非汉字" End If End Sub