/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 vote227 views1 answer
Vbnet hex to binary
VBA
0 vote274 views1 answer
Vb ternary
VBA
0 vote269 views1 answer
Vba registry settings
VBA
1 vote239 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote254 views1 answer
How to make a a msgbpx in vbs
VBA
2 votes219 views1 answer
Vba array contains
VBA
0 vote207 views1 answer
Vbnet make a string to unicode converter
VBA
2 votes178 views2 answers
Vba exit loop
VBA
0 vote226 views1 answer
How to set location and size of new from vb
VBA
0 vote245 views1 answer
Vbnet line chart showing extra space
VBA