ListObject::SelectedIndexChanged Event
Occurs when the value of the SelectedIndex property changes.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
This event is not raised if the header, Insert row or Total row is selected.
This event is raised if the SelectedIndex property is changed by either a programmatic modification or user interaction.
The following code example creates a ListObject on the current worksheet. It uses the SelectedIndex and AutoSelectRows properties to select the second row and to specify that the entire row is selected when the user clicks a row. The code example also creates an event handler for the SelectedIndexChanged event that displays a message box whenever a new row is selected.
This version is for a document-level customization.
This version is for an application-level add-in.
Show: