Message box if condition is met

[Hamza Oza]

Hi all,

I just need a simple message box that displays a certain text when cell A5>1. So cell A5 is the sum of A1:A4 and when the sum is greater than nil, I want it to display an error message.
I also need it to reset after the message box (Meaning it must display the error message every time the A5>1 so that the error persists until A5<1)

Any assistance will be highly appreciated.

 

[Zot]

The range A1:A4 has values that changes from time to time?