Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < Range("a:a").Find("序号").Row And Target.Column = Range("L:L").Column Then
Application.EnableEvents = False
If Len(Target) = 12 Then
If Right(Target, 1) = "Y" Or Right(Target, 1) = "Z" Then
MsgBox "ok"
Else
MsgBox "最后一个字符不是Y,或不是Z。"
Target = ""
End If
Else
MsgBox "字符长度不是12。"
Target = ""
End If
Application.EnableEvents = True
End If
End Sub
录入位数限制2.rar
(8.88 KB, 下载次数: 7)