Message Box Help - a potentially dumb Question

  • Thread starter Thread starter xxx
  • Start date Start date
X

xxx

I am trying to create a message box. For instance, if I type the
word "pools" in a specific cell, i want a message box to appear with
just a lousy "ok" button with a brief message.

Also, I want to create a message box in a different cell so that no
matter what value (or text) is entered into that cell, a message box
will appear with the same "ok" button and message.

Thanks in advanced.
 
No exactly the behavior you want, but you can get close with
Data=>Validation. Look at all the tabs and look it up in help.
 
And maybe you could just use an adjacent cell and put a formula:
=if(a1<>"pools","","OK-your message here")
and
=if(a1="","","Ok--your other message")
 
Back
Top