Creating a warning window

P

PCStechnical

I'm working on a timecard project. I want to create a popup window
(userform) when the values someone inputs on the worksheet for their
regular hours + other hours does not equal the time interval they
inputed.

Example: I input that I worked from 8:00am to 4:00pm (8hr day). I can
break down my hours between regular work hours and other hours
(overtime). If the employee puts in 5 regular hours and 10 other hours
for that day, obviously that is more than the 8 hour day they claimed
they worked.


If this scenario was true, I want a window to pop up telling them that
their hours don't equal.


CAN I DO THAT?


PCStechnical
 
C

CLR

How about just letting Excel do the math from the Start and Finish times and
the user not even have to enter anything except those?

Vaya con Dios,
Chuck, CABGx3
 
B

Bob Phillips

Use Data>Validation and use a type of Custom and a formula

=regular_hours+overtime_hours=totals_hours

it will error if this is false.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
S

SteveW

How about only posting it in 1 forum not 3.
You've got answers in all 3 now

Steve
 
P

PCStechnical

connected the data validation and it doesn't seem to be working.

If I put a data validation condition in a cell that has a formula in
it, will the validation not work?


What I have: cell 1 has the formula that adds regular hours +other
hours. Cell 2 gives me the total hours worked that day (also a
formula). In cell 1, I put a data validation of these settings
Allow: custom
Formula: =n7*
*n7 is where the number of total hours is located


any sugguestions on why the warning is not popping up?


PCStech
 
P

PCStechnical

well, since this is the first time i've used this, I didn't know how
fast the responses would be. Therefore, I just tried 3 forums to
increase my chances of a quick response.

Thank you for your quick response though. I know now that this forum
works quickly.
 
P

PCStechnical

I did a test one in another worksheet that looks like this
regular hours other total
6 2 8
6 8
8 8

the demensions are columns a:c and rows 1:4

questions:
which cell do I validate?
when I tried validating in cell d3 the formula I put was (=a3+b3=c3)
and nothing popped up. Solutions?
 
Top