Hi Experts,

I am preparing one user form to take validated entries from each associate. We are measuring each associate work time, hence using the attached user form they will fill details in all fields, input minute for one report for one day, then they will click "Done" which will append an entry in the active sheet. Now the idea is to retrieve data present in the Timesheet tab so that user can Update/Delete the records from the user form.

Let’s say Timesheet sheet has data for several dates. Now once the user selects a date E.g. 9/1/2012 then the very first entries of this date from Timesheet tab should reflect in all the boxes of the user form so that he can update the entry and say “Update” While clicking on update the entire row in Timesheet sheet should be updated. Similarly for Second entry of 9/1/2012 user will click on “Next” or “Previous” to access next or previous entry of 9/1/2012 and he will update and the same would be updated in corresponding rows in Timesheet tab.

Delete: would be used to delete existing entry present in database. Once any entry is selected and user clicks on “Delete” then the same entry (Entire Row) would be deleted and the next entry would go up

Total: Will display total number of Minutes entered in “TimeSpent” for whole day. E.g. While selecting 9/1/2012 it would show total of entire day, clicking next and previous would not make any difference to Total (If user updates entry then total box should update). Once user adds up entries for one day the Total box would show (Real-time) sum of minutes for this date.

There should be one check: Today is 2st Nov 12, if I want to start adding entries for 2nd Nov 12 and total for 1st Nov 12 is not 480, then user form should show one pop up message saying that “Timesheet entry for yesterday is incomplete”

I have everything setup except above. I have attached two files Test.xlsx and Test database (The database is one point location from where each contols of user form populates) You will need to change the path as per your system for better understanding.

I would really appreciate any help towards this. As I am new to VBA would like to learn how to complete this pending task.

Thanks a ton in advance.