'Declaration<System.ComponentModel.CategoryAttribute("Data")> <System.ComponentModel.DescriptionAttribute("Occurs when a range changes.")> Public Event RangeChanged As RangeChangedEventHandler
'UsageDim instance As WorkbookView Dim handler As RangeChangedEventHandler AddHandler instance.RangeChanged, handler
[System.ComponentModel.Category("Data")] [System.ComponentModel.Description("Occurs when a range changes.")] public event RangeChangedEventHandler RangeChanged
The event handler receives an argument of type RangeChangedEventArgs containing data related to this event. The following RangeChangedEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Range | Returns the range that was changed. |
It is important to note that some actions, such as insert or delete, will change cells outside of the range, and possibly even modify formulas in other worksheets or workbooks.
The RangeChanged event is always invoked on the thread which created the workbook view control, and a lock is always acquired on the workbook set associated with the workbook view control before RangeChanged is invoked.
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2