/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

3 votes210 views1 answer
Excel vba change format of cell
VBA
0 vote195 views1 answer
Vbs expand env var
VBA
0 vote207 views1 answer
Vba word pdf table to excel
VBA
0 vote195 views1 answer
Loop through lines in text file vb net
VBA
0 vote230 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
1 vote198 views1 answer
Vba delete file
VBA
0 vote199 views1 answer
Check if cell is dbnullvb.net
VBA
0 vote189 views1 answer
Do until vb.net
VBA
0 vote185 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote187 views1 answer
Vba option button selected
VBA