Change table record in userform

[S P P]

Change table record in userform

Change the code in the second column of the table in the userform

 

[Belleke]

Does this help? It is not clear to me.
Push change code button instead of register.

Private Sub CommandButton2_Click()
Set ws = Worksheets("Register")
Lr = ws.Cells(Rows.Count, 2).End(xlUp).Row
With ws
.Range("B" & Lr) = TextBox1.Value
If TextBox2.Value <> "" Then .Range("C" & Lr) = TextBox2.Value
End With
Unload Me
End Sub

 

[S P P]

It worked perfectly
Thanks
What would the code look like referencing a table
>>> use code - tags <<<

Worksheets("Register").ListObjects(1)