Modifocation time of a cell

[MoHassan]

Dears
Really i need your help as i want an equation or a code to detect the modification time of a certain cell as a static text

 

[Fishboy]

Dears
Really i need your help as i want an equation or a code to detect the modification time of a certain cell as a static text

Hi MoHassan, welcome to the boards.

Without knowing more information I will have to speculate somewhere as to what cell we are looking at and where you want the date and time stamp to go.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
     Range("B1").Value = Now()
End If
End Sub

Armed with the above you just need to right-click on the desired tab and select View Code. In the window that opens simply copy / paste in my code from above. Change the $A$1 part to the cell you want to track and the B1 to the cell you want to update with the date and time stamp.