How do I display a message box if a specific cell does not equal a given
number (say 100)?

Assume that I have two worksheets (Sheet1 and Sheet2) in a workbook.
If cell b7 in Sheet1 does not equal 100, I would like a message box to
appear to the user stating "Please review the numbers." The only
control for the message box should be an OK button.

After the OK button is clicked, it should return the user to cell a1 in
Sheet1.


---
Message posted from http://www.ExcelForum.com/