|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
感谢kevinchengcw 带我进入AU3
下面将写的一个身份证号码验证器的代码分享给大家,虽然不是EXCEL的范畴
$sff = InputBox ("身份证验证器","请输入十八位身份证号码")
If StringLen ($sff) = 18 Then
$r = 1
$s = 0
For $i = 17 To 1 Step -1
$s = $s + (2 ^ $i) * StringMid($sff, $r, 1)
$r += 1
Next
$sfx =Mod($s,11)
Dim $Array1[11]=[1,0,"X",9,8,7,6,5,4,3,2]
If $Array1[$sfx]<> StringRight($sff, 1) Then
MsgBox ("","审核结果"," 该身份证号码不正确"&chr(13)&chr(13)&"请到户口所在公安机关核对")
Else
MsgBox ("","审核结果","该身份证号正确")
EndIf
ELSE
MsgBox ("","审核结果","您录入的身份证号码为"&StringLen ($sff)&"位")
EndIf |
|