LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do update inventory Stephen Excel Discussion (Misc queries) 2 November 24th 06 02:02 AM
Cell References [email protected] Excel Discussion (Misc queries) 2 November 15th 06 11:37 PM
Using an offset formula for the reference in a relative reference Cuda Excel Worksheet Functions 6 November 15th 06 05:12 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Adding a row to worksheet does not update cell references in another. blausen Excel Worksheet Functions 5 February 25th 06 09:14 PM


All times are GMT +1. The time now is 06:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"