Search and Update

[siobeh]

Hello Forums!, can anyone help me with my search and update form?

I just want when in input a data in Textbox4, it will search it sheet1 and populate the Textboxes else a messagebox will prompt "No Records Found!".

Also, in Commandbutton1, when searching is successful, when i amend something in the textboxes and click the "Amend" button, that data will amend in sheet.

Thank you in advance.