I need help writing the following Macro:
I have some data that's computed let's say in cell A1 of an excel sheet. What I want to do is have a message box pop up when the numerical value from that cell goes over a certain limit.
eg. If cell A5's formula is =Sum(A1:A4). I want a warning message box to come up if A5>10.
I also need help writng a macro for another message box. In a sheet I'm working on, the user can input an expiration date in a certain cell (say A1). When that date has expired I want a message box to pop up telling the user that "The expiration date has expired".
Please help.
I have some data that's computed let's say in cell A1 of an excel sheet. What I want to do is have a message box pop up when the numerical value from that cell goes over a certain limit.
eg. If cell A5's formula is =Sum(A1:A4). I want a warning message box to come up if A5>10.
I also need help writng a macro for another message box. In a sheet I'm working on, the user can input an expiration date in a certain cell (say A1). When that date has expired I want a message box to pop up telling the user that "The expiration date has expired".
Please help.