/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 vote184 views1 answer
Vba full date format
VBA
5 votes190 views1 answer
Xl vba double quotes in string literal
VBA
0 vote203 views1 answer
VBA Sort RossetaCode
VBA
0 vote187 views1 answer
Ribbon show/hide
VBA
0 vote183 views1 answer
Vbnet find highest value in chart
VBA
0 vote188 views1 answer
Vba compare strings
VBA
2 votes138 views2 answers
Vba exit loop
VBA
0 vote195 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote195 views1 answer
Open file dialog in vb.net
VBA
8 votes279 views1 answer
Excel vba make a short integer from two bytes
VBA