Kicker
03-21-2007, 04:29 PM
I have searched the boards, but haven't been able to put anything together.
Regardless of where I am in the workbook or userform, I need to have a macro automatically run every 5 minutes and alert the user if certain conditions exist. for example
When an employee "starts" work, his emp code is entered and a record is made with name, emp code, start time. When he ends work, the record is completed with the end time. However, I need an alert to warn me when an employee has worked 10 hour or more. While I am working, I need the application to tell me that employee X has worked 10 hours.
Regardless of where I am in the workbook or userform, I need to have a macro automatically run every 5 minutes and alert the user if certain conditions exist. for example
When an employee "starts" work, his emp code is entered and a record is made with name, emp code, start time. When he ends work, the record is completed with the end time. However, I need an alert to warn me when an employee has worked 10 hour or more. While I am working, I need the application to tell me that employee X has worked 10 hours.