JPica,

I should have also said that if the cell that you want to monitor contains a
formula, you will need to have a second cell that contains just the current
value of the cell, and then use the calculate event to compare the cell with
the formula with the value cell, as below.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Calculate()
If Range("A1").Value < Range("A2").Value Then
MsgBox "Cell A1 changed!"
Application.EnableEvents = False
Range("A2").Value = Range("A1").Value
Application.EnableEvents = True
End If


"JPica" wrote in message
...
Is it possible to have VB continuously check a cell to
see if the value has changed?

JPica