I need help writing a Macro for a Form Control Button. In my spreadsheet, I would like the users of the spreadsheet to press this button "Verify MAOP" to determine if the MAOP they have chosen meets specific design criteria.

Upon pressing the Button, "Verify MAOP", I would like one of three message boxes to show up. Let's just say for simplicity that I have two design numbers in cells B1 and C1 (these numbers are calculated based on other inputs in the spreadsheet). The MAOP is listed in A1.

Cells B1 and C1 could be be an integer or "N/A" if one of the data inputs used to calculate the number has not been entered.

Therefore, there are 3 message boxes that would be displayed based on the following:

If A1 is greater than B1 OR C1, Then Display Message 1.
If A1 is less than both B1 AND C1, Then Display Message 2.
If B1 or C1 is "N/A", Then Display Message 3.