/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 vote447 views1 answer
Vba change active sheet
VBA
2 votes334 views1 answer
Vba file from path
VBA
0 vote367 views1 answer
How to call gcd in vba
VBA
0 vote319 views1 answer
Vba code to open a file with login rights
VBA
0 vote290 views1 answer
Excel vba milliseconds
VBA
-1 vote330 views1 answer
Vba code to add new column in table
VBA
0 vote336 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote333 views1 answer
Set font for ms chart vb.net
VBA
0 vote299 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote330 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA