Conditional Date and Time Change

[mbshafe]

I'd like to have the date and time in a cell update automatically when the value of another cell changes, however, I then want the date and time to remain until the other cell is changed again...can anyone give me a suggestion? TIA...Mike

 

[delaneyjm]

You'll need a Worksheet_Change event macro written.

What cell/range of cells would have the date and time in it? What cell/range of cells would you be modifying?

 

[mbshafe]

The sheet is called Position Detail, the cell with the date and time is Q3, the cell that will be changing is P3...thanks

 

[delaneyjm]

You will need to post this code in the Position Detail worksheet object in the Visual Basic Editor.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("P3")) Is Nothing Then
        Range("Q3").Value = Now
    End If
End Sub

 

[mbshafe]

Thank you very much!

 

[mbshafe]

I have encountered another problem...the date and time updates when I open the file and I want it to show the last time the value of the cell was changed. It is a manually inputted value, so it shouldn't be changing during any recalculation.

 

[mbshafe]

could someone else pls take a look at this? Thanks, Mike