Automatic date on cell value add | excel | VBA | excel interview question #vba #date #custom #viral
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
Related videos
How to Quickly Add Automatic Serial Numbers in...
Mr. EXCEL HACKS
Excel Automatically Sort When Data Changes or A...
ExcelTips247
How do I automatically create border if the cel...
ExcelTips247
Add Total Values for Stacked Charts in Excel: C...
ExcelTips247
How do I add vertical values to an Excel chart?...
ExcelTips247
How to count cells that contain specific value...
ExcelTips247
Get maximum of comma-separated values in a cell...
ExcelTips247
How to count cells that contain specific value...
ExcelTips247
How do I add a colon at the end of a cell in Ex...
ExcelTips247
How to add unit to cells in Excel - Excel Tips...
ExcelTips247
How do I add a mini calendar and date picker in...
ExcelTips247
Insert a date picker in Excel without add-ins ...
ExcelTips247