用函数left(string,6)取得前六个字符看是否是jzbh00,写个循环,逐个检查后面的数是否是“0123456789”里面的数字之一
Dim sTemp, sNumber
sTemp = "jzbh00**"
sNumber = "0123456789"
If Len(sTemp) >=7 Then
for i = 7 to Len(sTemp)
If InStr(sNumber,Mid(sTemp,i,1)) = 0 Then
Msgbox "格式不对!"
Exit For
End If
next
End If
用正则
Function Chack(sStr)
Chack = False
If sStr = "" Then Exit Function
Dim oRE
Set oRE = New RegExp
oRE.IgnoreCase = True
oRE.Global = True
oRE.Pattern = "^jzhb00[\d]+$"
IsInteger = oRE.Test(sStr)
Set oRE = Nothing
End Function