/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 vote171 views1 answer
Hello world vb.net
VBA
0 vote173 views1 answer
How to use if condition in time vba
VBA
0 vote184 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote186 views1 answer
Convert number to minutes in vba
VBA
0 vote184 views1 answer
Excel run macro every 5 minutes
VBA
0 vote168 views1 answer
Vba copy paste value only
VBA
0 vote223 views1 answer
Winforms dark title bar
VBA
0 vote174 views3 answers
Write to text file vb.net
VBA
0 vote188 views1 answer
Vba html document reference
VBA
0 vote191 views1 answer
Sendkeys vba selenium
VBA