/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 vote332 views1 answer
Vba len variant
VBA
1 vote358 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
8 votes409 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote347 views1 answer
Vba round to 2 decimals
VBA
0 vote348 views1 answer
Excel protect cells with formulas
VBA
5 votes360 views1 answer
Excel vba tool to help with refactoring code
VBA
5 votes375 views1 answer
Excel vba left word from Long Integer
VBA
1 vote325 views1 answer
How to do error handling in access vba
VBA
0 vote343 views1 answer
Excel vba chrw max value
VBA
4 votes339 views2 answers
Excel vba last column with data
VBA