hdevadiga
10-09-2012, 11:24 PM
Hi Friend,
While working on this file, i got an error.. In this file i have a userform which contain TextBox1, TextBox2 and Submit... I use the data range of A1:B7 in this which is mentioned below:
A B
Emp Code Deparment
1001 HR
1002 Finance
1003 Sales
My query is when i type "1001" in textbox1 than i should get "HR" automatically in textbox2 and when i click on submit button it should save in "Data" sheet.... Please help
Regards,
Hari
While working on this file, i got an error.. In this file i have a userform which contain TextBox1, TextBox2 and Submit... I use the data range of A1:B7 in this which is mentioned below:
A B
Emp Code Deparment
1001 HR
1002 Finance
1003 Sales
My query is when i type "1001" in textbox1 than i should get "HR" automatically in textbox2 and when i click on submit button it should save in "Data" sheet.... Please help
Regards,
Hari