hdevadiga
10-07-2012, 11:04 PM
Hi Friend,
I have a userform having two text boxe (TEXTBOX1 AND TEXTBOX2) and excel sheet too having two column mentioned below:
Emp Code Department
1001 HR
1002 Sales
1003 IT
My question is if i input the value "1001" in textbox1 than "HR" should automatically get populate in textbox2 and it get saved in sheet when i click on save button...
I have a userform having two text boxe (TEXTBOX1 AND TEXTBOX2) and excel sheet too having two column mentioned below:
Emp Code Department
1001 HR
1002 Sales
1003 IT
My question is if i input the value "1001" in textbox1 than "HR" should automatically get populate in textbox2 and it get saved in sheet when i click on save button...