Update Sheet from update in textbox

[Patriot2879]

Hi i hope you can help, i have a userform with a listbox which highlights the data in sheet1, when click on one of the rows in the listbox this populates the data into the textbox, but i am stuck as if i want to update the data by changing it in the textbox, i want to click on my update button to update the data in sheet1. please see attached my spreadsheet on dropbox, i hope you can help me please?

listbox view in userform(1).xlsm

 

[Patriot2879]

there are 5 textboxes - textbox1, textbox2, textbox3, textbox4, textbox5

 

[Patriot2879]

I hope you can help please?

 

[Patriot2879]

Hi any help on this please? i am really stuck on this and don't know where to go regarding the update button.

 

[Patriot2879]

Hi I have sort of got it to work now it updates the lsitbox now but how do i direct it to update sheet1 please in the code below?

Private Sub cmdUpdate_Click()
    If ListBox1.ListIndex <> -1 Then
        With ListBox1
            .List(.ListIndex, 0) = TextBox1.Value
            .List(.ListIndex, 1) = TextBox2.Value
            .List(.ListIndex, 2) = TextBox3.Value
            .List(.ListIndex, 3) = TextBox4.Value
            .List(.ListIndex, 4) = TextBox5.Value
        End With
    End If
End Sub

 

[Patriot2879]

Hi i have got it to update the ListBox but please can you advise how i get it to update Sheet1 instead?

Private Sub cmdUpdate_Click()
    If ListBox1.ListIndex <> -1 Then
        With ListBox1
            .List(.ListIndex, 0) = TextBox1.Value
            .List(.ListIndex, 1) = TextBox2.Value
            .List(.ListIndex, 2) = TextBox3.Value
            .List(.ListIndex, 3) = TextBox4.Value
            .List(.ListIndex, 4) = TextBox5.Value
        End With
    End If
End Sub

 

[Patriot2879]

hope you can help please?