Excel VBA + Userforms

[IThelp]

For my A-Level Coursework I have to design a fully functioning till system which contains staff data and payslips etc. I have designed a userform which enables you to add a new member. within this userform is a lookup box which brings up the persons name when you type their name in. I am trying to get all the data about the person to go into the text boxes on the userform when you double click on the person so their details can be etited. Also i wish for a new row to be created and the new staff data to be entered into that row when you click the add button. Any help with this would be extremely grateful.
many thanks

 

[awatt]

I have data from G11:L37. the VBA code should put data from reg1 into G38 but instead puts it into G2. Another thing is that i have a border going around so i would need new rows added below from G37 so that everthing remains within the border. Hence why I need the code to insert a new row below the last row which should be row 37. The code successfully put the infromation from each reg to the correct columns but not into the correct row.

Now you're talking!

Change the code to this:

LastRow = Cells(Rows.Count, "G").End(xlUp).Row + 1

 

[IThelp]

Now you're talking!

Change the code to this:

LastRow = Cells(Rows.Count, "G").End(xlUp).Row + 1

Thank you awatt,
It now successfully works, thank you so much for your help.

Another query I have for a smiliar userform in a different sheet is that would it be possible to add the data from the userform to a selected row?

again many thanks!