Right click on the Sheet and choose View Code. In here paste


Private Sub Worksheet_Calculate()
If Range("B2") = 100 Then Range("C2") = Now
End Sub


--
Regards
Dave Hawley
www.ozgrid.com
"Ken" wrote in message
...
I have a dynamic stock quote in cell "B2" ... in cell "C2" I want to record
the exact time that the stock price FIRST reachs a certain price. How do I
have this cell record this exact time only the first time the stock is at
this price and not change it later?
--
Ken