Maneesh Massey
Member
Hi,
I am working on an application using VBA in Excel 2013. I have a few userforms that collect information from the user and write it back to the worksheet in their respective columns.
There are essentially 5 important forms that do the job. Of the 5 forms, one is to add new agents, and the rest 4 forms take in information and write it to the worksheet based on certain criteria since the agent commenced his work and the agent's work done in the previous year. 2 forms write it to the left side (since the agent commenced his/her work) of the Agent_Detail worksheet while the remaining 2 forms send information to the right side (work done by agent in the previous year) of the Agent_Detail worksheet.
The problem is, somehow, only 2 rows of data are being written to the database for the Work Commenced side of the Agent_Detail worksheet. The previous year's part of the data has no problem at all, with all the entries being written to the database. Why is this happening ? I fail to understand the reason.
Please help me get this right. Appreciate all help. I've attached the file with this post.
Thanks a lot!
Regards,
Maneesh
I am working on an application using VBA in Excel 2013. I have a few userforms that collect information from the user and write it back to the worksheet in their respective columns.
There are essentially 5 important forms that do the job. Of the 5 forms, one is to add new agents, and the rest 4 forms take in information and write it to the worksheet based on certain criteria since the agent commenced his work and the agent's work done in the previous year. 2 forms write it to the left side (since the agent commenced his/her work) of the Agent_Detail worksheet while the remaining 2 forms send information to the right side (work done by agent in the previous year) of the Agent_Detail worksheet.
The problem is, somehow, only 2 rows of data are being written to the database for the Work Commenced side of the Agent_Detail worksheet. The previous year's part of the data has no problem at all, with all the entries being written to the database. Why is this happening ? I fail to understand the reason.
Please help me get this right. Appreciate all help. I've attached the file with this post.
Thanks a lot!
Regards,
Maneesh