I need a help in writing a VBA Code for my form.
Actually, I have created a form with 3 text boxes namely Employee No.,
Employee Name and Employee Department.
I have all the values stored in the excel sheet of same workbook.
I want the user to enter only the employee no. and the remaining 2 values(Emp
Name and Department) has to be retrieved from the excel sheet using VLOOKUP. I
was successful in getting the values for the employee no. existing in excel
sheet.

If the user enters the employee no. which is not existing in my excel sheet,
it should give the message asking the user to update the remaining 2 fields in
the form manually.

Can some one help me in this VBA code??