Mrunal Chauhan
Mrunal Chauhan
Programming language:Whatever
2021-07-15 19:04:55
0
Q:

how to update date and time automatically once id is entered in excel vba

Sarriesfan
Sarriesfan
Code: Whatever
2021-02-08 15:57:10 
If Target.Column = 2 And Target.Offset(0, 3).Value = "" Then
0
raster
raster
Code: Whatever
2021-08-06 03:48:45 
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 2 And Target.Offset(0, 3).Value = "" Then
        Target.Offset(0, 3) = Format(Now(), "HH:MM:SS")
    End If
End Sub
0

Tags

Related

New to Communities?

Join the community