Show Existing data from sheet in textbox and allow input in VBA userform

Hi there,

I wish the textbox can be filled with information from the sheet once i search with the ID.
For example, when i type 82412648 in ID textbox and click "Search" there is a lookuo function with the sheet "Masterlist", then the corresponding particulars of the ID, with include the SP name to transaction collected (column C to I) will be filled in the textbox.

After that, i will input figures in the textboxes when appropriate. I hope there will be an update function where at the end, all my inputted data will fill to the masterlist.

I have draft the template of the userform. Thankful if anyone can help with a few line of coding and i will try to finish it by myself.

Coded the search/find - the update just reverse (cells = textboxes)
I could have given far more compact code although that would have meant re-arranging your form.
Try to code the update - any problems ask on the forum.
torachan.