Good morning I am looking for a vba code that generates a msg box with a warning text if a value in a cell goes above or below a value. In sheet 1 I enter a value on A10 Sheet 2 shows the lower limit in A9 and the upper limit in A10. The code then looks at sheet 2 A9 and A10 if a value has been entered in sheet 1 A10 that is above or below the msg box For example Sheet 2, the limits are set to 2 and 4 On sheet 1 enter the value 1 in cell A10 and the msg box will appear Hope it's a little clear what I mean