View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claudio Silva Claudio Silva is offline
external usenet poster
 
Posts: 8
Default msgBox after update 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