The easiest way is using data validation. From the excel drop-down menus:
Data / Validation... Choose "custom" in the "allow" combo, then you can
specify your formula. Your formula can contain cell references and boolean
logic, just like a cell formula.


Bill


"PCStechnical" wrote:

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