/VBA/How to update date and time automatically once id is entered in excel vba

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

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

Source: stackoverflow.com

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

If Target.Column = 2 And Target.Offset(0, 3).Value = "" Then

Source: stackoverflow.com

Similar codes

5 votes174 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote180 views1 answer
Excel run macro every 5 minutes
VBA
0 vote183 views1 answer
Vba get relative cell address
VBA
1 vote168 views1 answer
Export datagridview to excel vb.net
VBA
0 vote183 views1 answer
Make your computer talk vbscript
VBA
0 vote170 views1 answer
Vba border weight
VBA
5 votes177 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote171 views1 answer
Excel vba clear filter
VBA
1 vote175 views1 answer
Random number generator vb.net
VBA
0 vote191 views2 answers
Excel vba number format file size
VBA