/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 vote175 views1 answer
Vb net check if file exists
VBA
0 vote167 views1 answer
Excel vba arrondir
VBA
2 votes186 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote176 views1 answer
Vb.net visible property dgv collumn not working
VBA
4 votes183 views1 answer
Excel vba check cell not empty
VBA
0 vote195 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote202 views1 answer
Excel vba add reference programmatically
VBA
0 vote179 views1 answer
Check if program is running vbnet
VBA
0 vote191 views1 answer
Enable macros on opening workbook vba
VBA
22 votes248 views1 answer
Excelvba check for directory
VBA