VBA USERFORM TO EXCEL DATABASE

[DYLANATT1999]

Hi,

So this query is in reference to a larger excel sheet. I have developed a calculation sheet and now want to add a feature of saving the values from the userform to an excel spreadsheet table / rows so there is a log and also people can edit at a later date

Once saved, I want the user to be able to search either the ID or the Project title and to load these values from the excel sheet into the userform again to allow the user to edit the values and then override the values that had already been entered. I am not sure how to override the values instead of creating a new ID

I have done a simplified version of the sheet, which hopefully if someone is able to guide me, I can then apply to the other sheet that I am working on.

I am relatively new to VBA, so the coding on the test sheet might need correcting to suit

DOWNLOAD SHEET

Thanks in advance!

 

[DYLANATT1999]

Also on vba userform to excel sheet