VBA. Userform to retrieve data and then save to existing row and not create new row

Hi,

I'm working on a userform for Insurance project. I'm looking to pull back quotes into a form from the spreadsheet, modify them and write them back to the spreadsheet but not creating a new entry - in otherwords updating that record.

I have the form working to add entries to the spreadsheet, and pulling them back in from a combo box, but need help with the code not to create a new row and update the current one.

Insurance.xlsm

Attached is the workbook so far.

Any help in the right direction would be much appreciated.

Many thanks,

Dave

Hi, Thanks for help. I've added the code... but not quite working.

I may have entered things in the wrong place - it compiled ok though.

I've added my amended workbook, if you have time to view the code i'd very much appreciate it.

I'm relatively new to VBA so still learning.

Insurance2.xlsm

Many thanks,

Dave

Hi,

Thanks for you help - Tinbendr. Its working well.

I did run into one issue that if you modify one record and update then try alter another without closing the form first, some information is lost from the table. This isn't a big problem though as its likely we'll only be editing one record at a time.

Appreciate you help.

Dave

- Jaslake, not sure why your receiving an error - the latest version added by Tinbendr works well.