Load data from row into vba form

[michiel]

Hello,
I hope someone can help me.
I have created a form in excel vba that stores data in a row with a header.
Everything works fine, however I would like users to be able to edit a certain row, using the same form that they used for entering the data.
So, I would like to have a vba code that loads the data of a row from a selected cell into the form.

Before showing all the vba, is there maybe a very simple example to do this so I can addapt it in my code?

Thanks a lot in advance!

 

[diddi]

this sample saves data from 10 textboxes called TextBox1 ..... TextBox10
into columns 1 to 10 on sheet1

Sub Sample()
    For col = 1 to 10
        Sheet1.cells(2,col) = Controls("TextBox" & col).value
    Next col
End Sub

' load from row number 34  (MyRow)

LoadData 34

Sub LoadData(MyRow as long)
    For col = 1 to 10
        Me.Controls("TextBox" & col).value = Sheet1.cells(MyRow,col)
    Next col
End Sub

 

[vanene]

This is superb!

Thank you for posting