Macro to bring up a pop up box

[jkharmer]

Hi,

I was wondering how I would go about writing a macro that would pop up if a value in a certain cell is greater than a set value. For example, if the cell b1 has a value of >50, I would want an alert box to pop up saying "Over Range". Ideally this should be automatic as soon as another value is entered into cell a1.

Any help would be great, Thanks, James

 

[doofusboy]

Another way to do this, without any code at all, would be to use Data Validation on all of your Input cells that pops an error message if user tries to enter a value greater than 50.