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

It is possible using the on change event but I would recommend using
conditional formatting.

With conditional format you can highlight cells and also give warnings.

Then you can have a on save macro to warn or stop the user from saving if
there is an error.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Claudio Silva" wrote:

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