Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
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
Data Validation lists update orginal cell with list update [email protected] Excel Worksheet Functions 3 July 11th 08 07:56 AM
msgBox after update a cell Claudio Silva Excel Discussion (Misc queries) 10 January 19th 07 10:22 AM
MsgBox in ComboBox Enter Event does not allow update Richard Excel Programming 1 March 3rd 06 08:15 PM
How to put the value form cell into the msgbox Jacek Excel Programming 3 May 30th 04 11:33 PM
Excel VBA - msgbox of excel regarding Update pando Excel Programming 0 April 1st 04 11:00 AM


All times are GMT +1. The time now is 12:13 PM.

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"