Replacement with Userform

[S P P]

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.

 

[Belleke]

Like this?

 

[S P P]

Belleke

Good Morning!

just as needed

Thanks again for the contribution.

I added

>>> use code - tags <<<

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

 

[Belleke]

Glad to help.