Message Box Help - a potentially dumb Question

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.
 
T

Tom Ogilvy

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.
 
D

Dave Peterson

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")
 
Top