Static Time Stamp Output

[bcohen408]

Hello,
I have an excel model where given a true value I need to see the time stamp that the first true occurs. This first time stamp would then be stored in a cell for reference. What I need is a macro to display the time of first true. Hopefully this makes sense.

Thanks in advance.
-B

 

[VoG]

Try along these lines: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Calculate()
If Range("A1").Value = True Then Range("B1").Value = Now
End Sub

Change A1 and B1 to suit.

 

[bcohen408]

Thanks you very much. With the =now() parameter of the code, if the macro were rerun wouldnt that give the new time? I would some how need to "freeze" that first time.

 

[VoG]

That is a static time, unlike the worksheet function =NOW().

 

[bcohen408]

Thank you very much, I forgot to mention that A1 changes dynamically and we would need the time stamp to be just one the first instance that A1 changes.