I don't see any use for a formula in the cell in the scenario you describe.
If there is a formula, then it is unclear why you would need any type of
validation.
The user enters two values and the third is calculated. - no disconnect.
--
Regards,
Tom Ogilvy
"PCStechnical" wrote in message
ups.com...
it seems though the validation option only works when the user actually
inputs a number instead of a formula computing a number in the cell you
want to validate. Is that true? If it is, is there anything else that I
can do.
Tom Ogilvy wrote:
You should validate the cells where the user is making entries. You say
the
user makes 3 entries Total, Regular, Overtime.
To be absolutely sure, you would need validation in each - but the
formula
would have to restrict entry only if there were entries in the other two
as
an example - although it would be more complex.
--
Regards,
Tom Ogilvy
"PCStechnical" wrote:
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?
Tom Ogilvy wrote:
You really don't need a macro for this. Look at Data=Validation and
use the
custom formula option. On the other two tabs in the dialog you can
specify
messages that pop up and so forth.
Debra Dalgleish
http://www.contextures.com/tiptech.html
look under D and then Data Validation.
--
Regards,
Tom Ogilvy
"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