hi dominicb

thank you for your reply, but my problem is not to be notified if the value
of a cell IS true, i need to be notified WHEN it's value changes to true

greetings
THW

"dominicb" wrote:


Good afternoon Thw

A cell cannot kick off a macro, but you could use an event procedure to
do something when the cell changes - paste this code into your worksheet
event pane and replace my msgbox with your code. And remember that my
code is checking for the value of cell A1 being false - your post
doesn't state which cell you want to watch.

Private Sub Worksheet_Calculate()
If Range("A1") = True Then
MsgBox "Cell A1 is true."
End If
End Sub

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=380107