• 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
Good Morning!

I need a userform that replaces code that is starting in F17 until the last found.

TextBox1 code replace

TextBox2 code to replace

Replaces if TextBox1 has a 4-digit code.
 

Attachments

  • SPP Replacement with Userform.xlsm
    14.7 KB · Views: 9
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:
Back
Top