Auto Filling a text box based on information in a different text box

[Benisato]

Good Day again,

I've got another fairly simple problem that I can't figure out for some reason.

I've got a userform that as multiple text boxes in it. One of those text boxes is Employee ID, and another one is employee name. I was wondering if it was possible to have the employee name box auto fill based on the data entered in the employee id box. I think it is possible to do using the Sub EmpID_Afterupdate(), but I'm not sure of the code I would use to take the data from the EmpID box, use it to lookup the employee name, and then put that information in the employee name box.

Any help would be greatly appreciated.

Regards,
Chris