MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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