Simple Msg Box
Posted by Tim on July 02, 2001 2:50 AM
I have wrot a simple if statement in collumn A... that checks the value in collumn K to see if it is ok...
If it is ok it write 0 if it isn't it write 1
what i would like is to have a Msg box popup if the value is one...
Cheers
Tim
Posted by Connie on July 02, 2001 6:10 AM
Tim,
You could use Validation under the Data menu. Choose allow: Whole Number, then Equal to: 1, and from there you can put in whatever message you want to pop up.
Connie
