Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgBox after update a cell
Hello,
I have a plan with hours A B C D E 8 12 13 17 8h Where, column A - Hour Arrived column B - Lunch Out column C - Lunch Back column D - Hour Left (work) column E - Sum of hours worked Then F G H 2 5 2 Where, colum F- Operation 1 colum G- Operation 2 colum H- Operation 3 I want to check the hours worked, and the and the hours distribuited on Oper. I need a macro that check if the value is right. eg: 8 hours worked (column E), than, sum column F,G,H and if the value is wrong like In the example, i want a msgBox, warning the user. Is that possible? Remembering that it should be, various row Waiting for your help! Regards from Brazil.. Claudio Marques |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do update inventory | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions |