log date when the file is open

[lezawang]

Hi

I want to log the date that a file is opened. For example, If I open the file today and I entered case#2 then the date should be today date in date column but if I open this file tomorrow for case#3 then tomorrow date should be in date column at the same time case #1 and 2 date should not change.

Is there any way I can do that?

Thank you so much

[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD]Case#[/TD]
[TD]Date -opened[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]15/10/2019[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]11/11/2013[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Paul Ked]

How are you entering the case#?

 

[lezawang]

Thank you for your reply. I am entering them manually. Thanks

 

[Michael M]

Paste this in the sheet module of the sheet you are working with

Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 1 Then
        If Target.Value <> "" Then
            Range("B" & Target.Row).Value = Date
        End If
    End If
End Sub

 

[lezawang]

This is great. Thank you so much. It is really amazing. Could you please break it down, I mean if you can explain to me what is "Target".
Also you said to copy this code in the sheet I am working on, and I did, but my question, by doing that, does that mean this code
is running in the background of the sheet. Thank you so much for the help once again.

 

[Michael M]

Target is the column that is being used to trigger the code in this case Column 1 or Column "A"
The code is only used by that sheet and isn't running until one of the "target" cells is used !!