/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 vote163 views1 answer
Vba table header name
VBA
0 vote150 views1 answer
Excel R1C1 mode
VBA
0 vote163 views1 answer
Excel filter by date not working vba
VBA
0 vote148 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote143 views1 answer
Vba border weight
VBA
0 vote161 views1 answer
Vbnet click on dgv cells
VBA
0 vote150 views1 answer
Excel vba protect sheet
VBA
0 vote161 views1 answer
Vba clear collection
VBA
1 vote143 views1 answer
Vba delete array element
VBA
0 vote165 views1 answer
Excel vba protect scenarios
VBA