Hi,
I created a User form (Excel+VBA). There are some fields(textboxes) which should be entered by user only once. Scenario:
A project manager enters his team members details to a form. He should enter his name , his emp id, his department in three text boxes.
Then he keep on entering team member details like Emp Name, Emp Id, Emp Address, Emp Mobile etc. When he click add button all the details should be saved to an excel. All the Emp details controls should be cleared but not the project manager details.
When i click ADD button data is saved to excel sheet. And ALL data is getting cleared. but for next emp detail also have to enter project manager details again. What i am trying to do is one project manager should enter his details only once and then he can keep on entering all the team members data using ADD button. Any help appreciated... Thanks in advance!!!
Sample file attached.
Bookmarks