Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Retrieving the values from Excel Sheet into form

  Asked By: Diane    Date: Jan 30    Category: MS Office    Views: 1215
  

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??

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Retrieving the values from Excel Sheet into form Or get search suggestion and latest updates.




Tagged: