/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 vote143 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote121 views1 answer
How to self delete a vbscript file
VBA
0 vote150 views1 answer
.net dark title bar
VBA
0 vote132 views1 answer
Excel text to columns line break
VBA
0 vote157 views1 answer
If statement vdhl
VBA
0 vote151 views1 answer
Vbscript Trim
VBA
4 votes154 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
31 votes267 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote181 views1 answer
Vbnet add axis labels to chart
VBA
0 vote149 views1 answer
Vba type variable
VBA