Worksheet selection change in Excel VBA

Описание

Event Procedure Excel VBA - worksheet_SelectionChange
Highlight Row Column of Active Cell within range instead of entire row

Excel has the ability to automatically run/execute any code when selection of cell changes in Excel worksheet.
By Default, Events are enable in Workbook and disabling events applies to all the workbooks. For Example, if we disable the events in one workbook and would like to open another workbook which has event then it will not work.
Enable Events: Application.EnableEvents=True
Disable Events: Application.EnableEvents=False
Worksheet SelectionChange events occurs when we select any cell/range in a worksheet or moved from one cell to another. When this events execute, it will receive a range object as its target.
In today’s video we will create a code to highlight row and column of selected cell in excel that will be present in dataset only.
Intersect: This is range/cell which present in target(Range) and defined area which is considered for validation.