• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Replacement with Userform

S P P

Member
Belleke

Good Morning!

just as needed

Thanks again for the contribution.

I added

>>> use code - tags <<<
Code:
If Len(TextBox1.Value) <> 4 Then
MsgBox "Textbox must contain a 4-digit code.", vbInformation, "Digit code is not valid"
TextBox1 = ""
TextBox1.SetFocus
Exit Sub
End If
 
Last edited by a moderator:
Top