Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msgBox sum values | Excel Discussion (Misc queries) | |||
Inserting values in MsgBox | Excel Programming | |||
MsgBox | Excel Discussion (Misc queries) | |||
Custom MsgBox using values from 2 different cells | Excel Programming | |||
format values in MsgBox? | Excel Programming |