本帖最后由 zjdh 于 2011-9-17 16:08 编辑
那就加一句判断;
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1 = "" Then Exit Sub
If Mid(Me.TextBox1.Text, 1, 1) <> "#" Then
MsgBox "※※※※※流水号不正确缺少“#”,请检查※※※※※", vbCritical + vbOKOnly
Beep
Cancel = True
End If
End Sub