Time Stamp without change

[AntonyY]

I've got a speadsheet that will need a time stamp. The entries will b
going into A1:A10 and in B1:10 will be the time stamp. But all th
time stamps that I seen on this forum change the time again if I chang
a entry in A1:A10. I need the times in B1:B10 to be hard coded so the
do change upon amendments in A1:10

Regards


Anton

 

[Harald Staff]

Hi Anthony

Time stamp of what ? When should it change ?

HTH. Best wishes Harald

 

[AntonyY]

Hi Harald

In column A a person will enter there initals, at this point in colum
B I will need the time stamp of when this happens. The reason I need i
hardcoded it that if somebody makes a mistake and puts there inital i
the wrong row it will change the time. Then I've lost the real tim
that, that person arrived.

Regards

Anton

 

[Harald Staff]

DateTime in B only if B is empty then ? Put in the worksheet module:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cel As Range
For Each cel In Target
If cel.Column = 1 Then
If cel.Offset(0, 1).Value = "" Then
cel.Offset(0, 1).Value = Now
End If
End If
Next
End Sub

HTH. best wishes Harald