I went ahead with the conditional formatting and an If statement. I merged a
bunch of cells together and made a big red box that said my message. Your
point about them closing the message box and forgetting it or maybe not
reading it was good. This way the big message won't go away until the error
is fixed. Thanks for the help- like I said I didn't think about a msgbox
being less annoying.
--
Thanks,
Nikki


"Bob Phillips" wrote:


"Sloth" wrote in message
...
Couldn't you create some code that toggled a comment box when the sheet
recaclulates? That way when the sheet recalculates it won't show a msg
box,
only show the comment. And if the comment is already showing it won't do
anything. I don't know how to do it, but I assume it would be easy for
someone familiar with the language.

Same problem. If the users are a boit slow, why would they look at the
comments?

If I were making the file, I would make the formula output an error msg
instead of the result. For instance...
=IF(A1+B112,"Result is too high, please adjust values.",A1+B1)

I would use conditional formatting.