/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 vote209 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
3 votes208 views1 answer
Excel vba last row in range
VBA
5 votes235 views1 answer
Excel vba first byte from INTEGER
VBA
1 vote216 views1 answer
Excel vba force recalculation
VBA
2 votes209 views1 answer
Date format for ms chart vb.net
VBA
5 votes222 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote211 views1 answer
Vba file chooser
VBA
0 vote251 views1 answer
Vbnet add axis labels to chart
VBA
1 vote207 views1 answer
Highlight selected cell in excel vba
VBA
22 votes500 views1 answer
Excel vba check if directory exists
VBA