Automatic date on cell value add | excel | VBA | excel interview question #vba #date #custom #viral - video Dailymotion

Name: Automatic date on cell value add | excel | VBA | excel interview question #vba #date #custom #viral
Uploaded: 2023-02-13T22:51:25+00:00
Duration: 39 s
Channel: Spreadsheet Lovers
Description: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("B:B")) Is Nothing Then Target.Offset(0, 4).Value = Date End If End Sub

Spreadsheet Lovers

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range("B:B")) Is Nothing Then Target.Offset(0, 4).Value = Date End If End Sub

Automatic date on cell value add | excel | VBA | excel interview question #vba #date #custom #viral

Category

Be the first to comment

Recommended