Search and Update

looks closely JapanDave , just need some modifications here:

1. When the user click Amend button, i just want to clear the textboxes and combobox so that
user can search another data and not exit the form. I will make a button for exiting.

2. When user enter a data in textbox4 that is not in sheet1, messagebox will prompt "No Records Found!".


Also, is it possible to run the code eventhough the combobox1 enabled set to false in userform intialize event? I just want textbox4 will only enabled when userform initialize.