View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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