Sunday, February 7, 2010

How can i make a message box appear when an IF statement = FALSE in Microsoft Excel (2003)?

If statement= false


MsgBox (';Hello world';)





Let me know if you need anything moreHow can i make a message box appear when an IF statement = FALSE in Microsoft Excel (2003)?
The above statement is if you want to use a macro: there are resources to show you how to do that with a macro here:





http://www.youtube.com/view_play_list?p=鈥?/a>





But it might just be easier for you to use data validation Alt + D + L and then go to the ';Error Alert'; tab and enter an error message and set it to popup when the value is false.

No comments:

Post a Comment