Static Date/Time stamp once correct option is selected

[Andrew5150]

I trying to setup a spreadsheet for multiple users on SharePoint.

I have a status column which is setup with a data validation dropdown list.

And a column which will contain a date/timer stamp.

I want the date/time stamp only to appear once a certain option is selected from the status column, and once selected to remain static even if F9 is pressed.

I have worked out a work around or sorts, but it not as functional as my request above.

Many Thanks in advance

 

[SteveO59L]

something along the lines of

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Target.Offset(0, 1) = Time
End If
End Sub