Message box if values in column are less or equal to 0

Hi,

I have a column (O4:O46) of values that updates automatically according to a formula. When any of these values are less than or equal to zero, I would like for a message box (vbOKOnly) to pop up reading "Updates are available.


Any help would be greatly appreciated.

Thank you!

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Calculate()
Dim c As Range
For Each c In Range("O4:O46")
    If c.Value <= 0 Then MsgBox "Updates are available", vbInformation
Next c
End Sub

Works perfectly. Thank you so much for the fast response!