hi,

i have created a userform where data can be input and when the user selects OK it puts the data in the correct order in the next row.

however, i want to create a 'edit' button where the user can click which brings up a form to select which item they want to edit.

when they click on the item and click a command button, i want it to go back to the original form and re-populate it

i have the below code which only displays the list.... and now im stuck on what i need to happen when the command button is clicked


Private Sub UserForm_Initialize()

    With ListBox1
        lastrow = Sheets("Adding funds").Range("A65536").End(xlUp).Row
        .ColumnCount = Sheets("Adding funds").Cells(1, 1).CurrentRegion.Columns.Count - 7
        .RowSource = "A2:J" & lastrow
    End With

End Sub