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

Spreadsheet Lovers 2023-02-13

Views 7

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

Show more

Download

Report form

RELATED VIDEOS

Excel (Macro) VBA Part-2 | VBA - Cell Referencing | Debug Function - Step into | VBA Coding in Hindi

play

Excel (Macro) VBA Part-2 | VBA - Cell Referencing | Debug Function - Step into | VBA Coding in Hindi

Insert picture in Excel cell automatically - Excel Image Assistant

play

Insert picture in Excel cell automatically - Excel Image Assistant

How to transfer data from one workbook to another automatically using Excel VBA

play

How to transfer data from one workbook to another automatically using Excel VBA

Excel Vba Activecell Select Cell

play

Excel Vba Activecell Select Cell

Excel Vba Cells Tutorial

play

Excel Vba Cells Tutorial

Excel VBA Programming Basics Tutorial # 2 | Introduction to Cells,Range and ActiveCell

play

Excel VBA Programming Basics Tutorial # 2 | Introduction to Cells,Range and ActiveCell

Excel Vba Date Time Example

play

Excel Vba Date Time Example

Coloring cells in excel automatically

play

Coloring cells in excel automatically

Adding comment to cell in MS excel

play

Adding comment to cell in MS excel

How to MERGE Cells & Add a Title on Microsoft Excel On a Mac - Basic Tutorial | New

play

How to MERGE Cells & Add a Title on Microsoft Excel On a Mac - Basic Tutorial | New

How to do math to multiple cells in microsoft excel (add/subtract/divide/multiple & formulas)

play

How to do math to multiple cells in microsoft excel (add/subtract/divide/multiple & formulas)

How to Excel Add Data Text or characters to multiple cells within a spreadsheet

play

How to Excel Add Data Text or characters to multiple cells within a spreadsheet