/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 vote152 views1 answer
How to open cmd with vbd
VBA
0 vote205 views1 answer
Make your computer talk vbscript
VBA
1 vote203 views1 answer
Random number generator vb.net
VBA
4 votes196 views1 answer
Excel vba check cell not empty
VBA
0 vote225 views1 answer
Vba DisplayGridlines
VBA
5 votes227 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote222 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote191 views1 answer
Vbnet get file name from path
VBA
5 votes232 views1 answer
Excel vba last byte from INTEGER
VBA
5 votes183 views1 answer
Vba array worksheet.index
VBA