/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 vote183 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote184 views1 answer
Refer to resource using string variable vb.net
VBA
3 votes206 views2 answers
Vba date to string
VBA
0 vote184 views1 answer
How to set location and size of new from vb
VBA
0 vote227 views1 answer
Wpf dark title bar
VBA
0 vote187 views1 answer
Menus act like radio buttons vb.net
VBA
4 votes177 views1 answer
Excel vba check cell not empty
VBA
4 votes188 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
1 vote176 views1 answer
Add control vb
VBA
0 vote176 views1 answer
Vba change named range address
VBA