ListObject::SelectedIndex Property

 

Gets or sets the index of the row that is currently selected.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

C#
C++
F#
VB
Copy 
property int SelectedIndex {
	int get();
	void set(int value);
}

Property Value

Type: System::Int32

The index number of the currently selected row.

This property is 1-based, not 0-based. The first data row in a ListObject control has an index number of 1.

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.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

This version is for an application-level add-in.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.
Return to top
Show: