msgBox after sum values
 

Hello,

I have a plan with hours

A B C D |
E F
Enter Lunch/In Lunch/Out Out | Oper1
Oper2
08:00 12:00 13:00 17:00 | 05:00
04:00

Well, that´s the hours worked, and the Oper, is how I distrib my
worked hours. I need a macro that check if the value is right... In the
example is wrong.. When this happens, i want a msgBox, warning the
user. Is that possible?
Remembering that it should be, for every day, not only on row..

Waiting for your help!

Regards from Brazil..

Claudio Marques

msgBox after sum values
 

Why not just use a formula to calculate it correctly?

=B1-A1

and

=D1-C1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Claudio Silva" wrote in message
ps.com...
Hello,

I have a plan with hours

A B C D |
E F
Enter Lunch/In Lunch/Out Out | Oper1
Oper2
08:00 12:00 13:00 17:00 | 05:00
04:00

Well, that´s the hours worked, and the Oper, is how I distrib my
worked hours. I need a macro that check if the value is right... In the
example is wrong.. When this happens, i want a msgBox, warning the
user. Is that possible?
Remembering that it should be, for every day, not only on row..

Waiting for your help!

Regards from Brazil..

Claudio Marques