Populate Userform with values from table

Hi. I have a sample spreadsheet with userforms that I need help with.

Userforms:
ContactSearch
ContactEdit

ContactSearch:
There is a button called "Open Contact" that currently navigates to the record in the table using the following code:

Please Login or Register  to view this content.

I want it to open the "ContactEdit" form and populate the fields with the items from the table. How do I change the code to make that happen?

Then, I want to re-save the changes to the same line in the table. I copied the "ContactAdd" form, so the "CmdSaveChanges_Click" code puts the changed information on the next open line instead of on the same line it came from. How do I change the code to do what I want? (I didn't input all of it here since it is so many lines. All of the lines are basically the same, so here is a snipet)

Please Login or Register  to view this content.

Thank you mehmetcik. This is very helpful.

All of that works, but when I click the "Save Changes" button on the ContactEdit userform, it still adds a new row to the table instead of overwriting the existing row.

How do I change this code to make it overwrite? I know it has to do with the LastRow portion, I just don't know what to change that to. (I am only posting the first part of the code since the bottom part is just more of the same.)

Please Login or Register  to view this content.

Also, I have this code to clear the form, but it does not clear everything. I found this on another site. How can I change this to completely clear the form?

Please Login or Register  to view this content.

I really appreciate your help.

Thank you! This works great. I appreciate your help.

Sorry to open this back up, but I am having trouble with the changes in my actual spreadsheet. The changes in Sample2.xlsm above work great in the sample, but it crashes Excel in my actual spreadsheet every time I click to add a contact to the table, from both the ContactAdd and the ContactEdit userforms.

I suspect it has something to do with the Global Variable "Entry", but not sure. Is there another way to accomplish the copying without that variable?

Nevermind! I figured it out. User error. Shocking, I know.