/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 vote163 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote194 views1 answer
How to enter Vbox manage commands
VBA
0 vote171 views1 answer
Excel vba calculate
VBA
0 vote183 views1 answer
Vba vbcrlf chr
VBA
0 vote170 views1 answer
Ribbon show/hide
VBA
0 vote173 views1 answer
Vb.net change cursor to wait
VBA
0 vote169 views1 answer
Vba option button selected
VBA
0 vote157 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote177 views1 answer
Export datagridview to excel vb.net
VBA
1 vote161 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA