/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

0 vote225 views1 answer
Excel vba range contains
VBA
0 vote235 views1 answer
Excel run macro every 5 minutes
VBA
0 vote225 views1 answer
Vbnet check if string is only symbols
VBA
0 vote229 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote242 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote254 views1 answer
Test if form is open vb
VBA
0 vote222 views1 answer
Vba pass named range to function
VBA
0 vote232 views1 answer
Return na vba
VBA
4 votes221 views1 answer
Excel formula for last non-empty cell in a column
VBA
25 votes293 views2 answers
Excel vba folder exist
VBA