Timestamp in Reference to a Change in Value of a Cell

Hi everyone,
I would like to ask if there is a way to create a timestamp if the active cell changes to certain value--let's say "IN PROCESS".
I created a code but it doesn't register/respond during the time the cell changes into "IN PROCESS" but instead when you click the activecell with "IN PROCESS" in it. Here's the code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Value = "IN PROCESS" Then
Cells(Target.Row, 5).Value = Time()
End If
End Sub

I'm just a beginner and I would like to ask if there is a way to register the time in response to a change in the Active Cell from one value to another.

-Martin

Hi Fotis 1991,

I tried using excel formulas but there is a need to use VBA because I realized that excel formulas can't provide time stamps that stay permanent. They change during saving or during the time you accidentally click the cell and press Enter. I'm having difficulty because there are two adjacent cells that I need to change in reference to a specific change in the active cell. For example, during the time the activecell changes to "IN PROCESS" it does a time stamp on the -Time Start- column and when the active cell changes to "DONE" it does a time stamp on the -Time End- Column.

Thank you by the way. Your reply to this thread is highly appreciated.

-Martin

Hi Tom,

I tried your code but it still produces the same result like the first code I provided. The improvement is regarding the Target.Offset which now makes it easier to assign the adjacent cell in reference to the activecell. The timestamp however does not register in response to a change in the activecell from one value to another but instead only verifies if the activecell contains "IN PROCESS" and if it does, then performs a timestamp. Therefore there is a need to click the the cell containing "IN PROCESS" again in order to perform a timestamp. However, with this setup the timestamp is invalidated since by accidentally clicking the cell or clicking it for example to change the value into "DONE" will change the registered time of the adjacent cell.

Thank you for your reply. The help you have provided is greatly appreciated.

-Martin