Save TextBox value to TABLE

I have built a UserForm that saves data to a spreadsheet (ANALYSISDB), The UserForm has 10 TextBoxes for data entry, a ListBox to view the data, the ability to search and double click within the ListBox to select an entry. I have 5 CommandButtons to SAVE, RESET, UPDATE, SEARCH and DELETE data.

On the Sheet with the data I have a button ("Input Data") to call the User Form

I would like to create a TABLE of the Data for further use in a bigger Excel Model. When I insert the table over the existing data The UserForm still works, All the commands work EXCEPT the Save Button. This is no supprise but I cannot find any help online with regards this challenge. Can anyone help ?

I am not a programmer and have limited VBA skills, all coding has been done with help from Google.

I have enclosed the worksheet for reference.

Hope this is a quick fix.

Simon

I see the "save" button adds data to the bottom row. Can you explain how it is not working?