Populate a UserForm field with value from excel sheet

[onmyway]

Hi All,

Thank you in advance for helping me (again)!

I have created a simple UserForm that searches for an ID number on sheet1, column A. The search finds the field, selects the row.

What I want: After successfully finding the field, I would like to click a button "Update", that then populates a field on the UserForm. This is just for a sample. May aim is to populate a whole form with various fields in the end.

I have attached my sample doc.

Thanks!