If time.Value = TimeSertial(0,10,0) Then
MsgBox ("Prepare to begin Meeting")
End If


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Texas Aggie" wrote in message
...
Here's my code:

Dim time As Range
Dim ws As Worksheet
Set ws = ActiveSheet
Set time = ws.Range(B10)

If time.Value = Format(Range("TimeLeft").Value, "00:00:10:00") Then
MsgBox ("Prepare to begin Meeting")
End If

What I am trying to do is display a message when the clock reached 10
minutes or 00:00:10:00. The format of the cell is dd:hh:mm:ss;@. Thanks in
advance.
--

Fighting Texas Aggie Class of 2009