Userform: Retrieve data from excel sheet and overwrite with new data in the same rows

Hello,

I am new to VBA, I have created a userform with multipage, has two page that help to add new record in a excel sheet. Data has a unique reference no.(TxtRef.Value) for each record. I am trying to add a button to load the added data for a specific record using reference no back to userform so that it can be updated and overwrite back to the sheet in the same row, So far it is adding new record correctly. I do not know how to populate all the fields of the of an existing record and overwrite it back to the same row instead of adding a new record. Below is my codes

I thank you in advance for your time and effort.

Thanks,
Pbawal

Please Login or Register  to view this content.