View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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.