• 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.

Change table record in userform

S

S P P

Member
Change table record in userform

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

Attachments

  • Register Change.xlsm
    23.9 KB · Views: 7
Does this help? It is not clear to me.
Push change code button instead of register.
Code: 
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
 
It worked perfectly
Thanks
What would the code look like referencing a table
>>> use code - tags <<<
Code: 
Worksheets("Register").ListObjects(1)
 
Belleke

It is not changing according to the name you type in textbox1

You have to change the code referring to the name entered in texbox1
 

Attachments

  • Register Change1.xlsm
    26.2 KB · Views: 0
You must log in or register to reply here.
Back
Top