Pop-up message

[FOXL]

Hi,

I have the following question:
I have 2 columns A, B and C. I have column A programmed so that when the value of C is X, the value in B will be the staring value. And A is programmed so that the value of input B is the difference between the input value and the starting value.

I would now like to make a pop-up message so that when A has a value lower than 5 it gives a warning message.

I have programmed the following:

Private Sub Worksheet_Calculate()

If Range("A1").Value <> "" And Range("A1").Value > 5 Then
    MsgBox "Warning"

Else
    
End If
End Sub 

This program works but now I would like to apply it on the entire colomn of A. So If I start a new thing by putting an x in C and therefore a new staring value in B. Eventually when A is again lower than 5, it will pop up.

Regards

[AliGW]

Administrative Note

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect.

1901 is a release, but what is the version - Excel 2019 or MS 365? Thanks.