/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 vote303 views2 answers
Vba remove first 2 characters from string
VBA
0 vote329 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote307 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote319 views1 answer
Vba copy file
VBA
1 vote324 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote409 views1 answer
Wpf dark title bar
VBA
0 vote333 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote302 views1 answer
Excel vba disable alerts
VBA
1 vote334 views1 answer
Set font for ms chart vb.net
VBA
1 vote295 views1 answer
Excel vba hide zero values
VBA