/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 vote382 views1 answer
Excel vba clear filter
VBA
0 vote379 views1 answer
Return na vba
VBA
3 votes367 views1 answer
Excel vba get the workbook full file name with path
VBA
2 votes388 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote403 views1 answer
Pivot data source not accepting table named range vba
VBA
4 votes355 views2 answers
Vba array length
VBA
0 vote378 views1 answer
Vba html document reference
VBA
1 vote389 views1 answer
How to put a gridpain in a vbox
VBA
0 vote336 views1 answer
Create new worksheet excel visual basic
VBA
0 vote322 views1 answer
How to sort datagridview in vb.net
VBA