/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

1 vote353 views1 answer
Vbs run
VBA
5 votes345 views1 answer
Excel vba high word from Long Integer
VBA
1 vote339 views1 answer
Excel vba first and last row and column in range
VBA
0 vote332 views1 answer
Excel vba populate array with cell values
VBA
0 vote356 views1 answer
Vbnet hex to binary
VBA
0 vote352 views2 answers
Get excel file from email attachment in vba
VBA
8 votes451 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote371 views1 answer
Add text to Shape VBA
VBA
0 vote364 views1 answer
Vb ternary
VBA
22 votes574 views1 answer
Xl vba check for folder
VBA