PDA

View Full Version : Display Data from Two Sheets



gyan123
09-25-2017, 05:46 AM
Hi Friends.........i am new to VBA programming

I create a Userform1 enclosed file for ready reference........

1. Employee Details exist in Sheet1
I want, When i run my Userform1 and enter the Employee Code in TextBox1, the Employee's details fill up in Employee Details Frame i.e. S.No., Employee Name, Nature etc.


2. Monthly Subs Amt. exist in Sheet2
When i click on Monthly Subs Amt the employee code which we enter earlier in TextBox1 auto display in TextBox10 and data should be display in Textboxes i.e. S.No., Employee Code, Employee Name, Date of Birth, Date of Aptmnt etc.

How to do this i attached a Picture of what i want please see