canselmi
03-30-2008, 10:16 PM
I have 7 worksheets (daily timesheets) that allow an employee to fill out hourly time. I have 17 rows and at the end of each row there is a checkbox that the employee can check if they have to take off from work and come back later. We call this split time.
I have an 8th worksheet that is the timesheet summary. I need one cell on this summary worksheet to indicate (maybe a check mark) if one or more of the checkboxes are checked for that day. This will let accounting know to look at that days timesheet instead of the summary page.
I think I might need an array, but I have no experience with an array.
I've started with the following code, but got nowhere:
Private Sub Boxeschecked ()
If sheet1.checkbox1 & sheet1.checkbox2 & sheet1.checkbox3 & sheet1.checkbox4... = true
then Activesheet.range (A1) = (I'm lost here)
I have an 8th worksheet that is the timesheet summary. I need one cell on this summary worksheet to indicate (maybe a check mark) if one or more of the checkboxes are checked for that day. This will let accounting know to look at that days timesheet instead of the summary page.
I think I might need an array, but I have no experience with an array.
I've started with the following code, but got nowhere:
Private Sub Boxeschecked ()
If sheet1.checkbox1 & sheet1.checkbox2 & sheet1.checkbox3 & sheet1.checkbox4... = true
then Activesheet.range (A1) = (I'm lost here)