/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 vote273 views1 answer
Excel vba concatenate range
VBA
8 votes360 views1 answer
Vba make integer
VBA
0 vote298 views1 answer
Excel vba current folder
VBA
0 vote312 views1 answer
VBA Sort RossetaCode
VBA
1 vote335 views1 answer
How to put a gridpain in a vbox
VBA
0 vote300 views1 answer
Excel vba extract year
VBA
0 vote307 views1 answer
Select case vba
VBA
0 vote322 views2 answers
Open url from vba
VBA
0 vote325 views1 answer
Vba variable number of arguments
VBA
0 vote288 views1 answer
Vbide vbproject reference
VBA