I would also like to be able to edit/update the form and update the information on the speadsheet accordingly.
What I want to do next is click on the surname on the speadsheet and call up the userform with the fields complete for that person.
I have the following code to put data from a VBA userform into Excel
