If then Message Box
"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.
|