Creating User Form to input payroll hours for a 2 week period

[shelbsassy]

I am wondering if this is even possible. Here is the scenario:
I have a workbook with 3 sheets: Employee and Rate; Date,Pay Period, and Month; and then a third sheet to capture data which has Employee, Date and HoursWorked.

What I would like to do is create a user form that can input the name, date and hours, only I dont want to have to keep hitting submit after every date. Is there a way to have it so the employee name is a drop down, then the pay period is a drop down, and then the pay period will populate with all of the appropriate dates for the period and then I can just enter the hours in every date and hit enter?

I know initially what the problem is just dont know a way around it. I realize every record with Employee Hours and Date will have to be uniique so I dont know how I can get sround the tediousness of selecting the user, then selecting the date and entering the hours 14 times for each person every pay period.

Is anything like this possible?

Thanks for any assistance.