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

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

it is possible, just attache any workbook with dummy data, which presents your source data structure

so let say you have
text1 - employee name
text2 - employee ID
sheet1 - source sheet

in event afterupdate of control text1
place code

Please Login or Register  to view this content.

it would be better if you can attach any sample workbook