ListObject.Deselected Event

Definition

Namespace:

Microsoft.Office.Tools.Excel

Assemblies:

Microsoft.Office.Tools.Excel.dll, Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Occurs when selection moves from the ListObject control to outside of the ListObject control.

public:
 event Microsoft::Office::Interop::Excel::DocEvents_SelectionChangeEventHandler ^ Deselected;

event Microsoft.Office.Interop.Excel.DocEvents_SelectionChangeEventHandler Deselected;

member this.Deselected : Microsoft.Office.Interop.Excel.DocEvents_SelectionChangeEventHandler 

Event Deselected As DocEvents_SelectionChangeEventHandler 

Event Type

DocEvents_SelectionChangeEventHandler

Examples

The following code example creates a ListObject and a Deselected event handler. When the ListObject is selected and then an object outside of the ListObject is selected, a message is displayed that indicates that the selection has changed.

This version is for a document-level customization.

private void ListObject_Deselected()
{
    Microsoft.Office.Tools.Excel.ListObject list1 = 
        this.Controls.AddListObject(
        this.Range["A1", "C4"], "list1");
    list1.Deselected += new 
        Microsoft.Office.Interop.Excel.
        DocEvents_SelectionChangeEventHandler(list1_Deselected);
}

void list1_Deselected(Microsoft.Office.Interop.Excel.Range Target)
{
    MessageBox.Show("List1 is no longer selected.");
}

WithEvents DeselectedList As Microsoft.Office.Tools.Excel.ListObject
Private Sub ListObject_Deselected()
    DeselectedList = Me.Controls.AddListObject( _
        Me.Range("A1", "C4"), "DeselectedList")
End Sub

Sub List1_Deselected(ByVal Target As _
    Microsoft.Office.Interop.Excel.Range) Handles DeselectedList.Deselected
    MessageBox.Show("The list object is no longer selected.")
End Sub

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

private void ListObject_Deselected()
{
    Worksheet vstoWorksheet =
       Globals.Factory.GetVstoObject(this.Application.ActiveWorkbook.Worksheets[1]);
    ListObject list1 =
        vstoWorksheet.Controls.AddListObject(
        vstoWorksheet.Range["A1", "C4"], "list1");
    list1.Deselected += new
        Excel.DocEvents_SelectionChangeEventHandler(list1_Deselected);
}

void list1_Deselected(Microsoft.Office.Interop.Excel.Range Target)
{
    System.Windows.Forms.MessageBox.Show("List1 is no longer selected.");
}

WithEvents DeselectedList As ListObject
Private Sub ListObject_Deselected()
    Dim NativeWorksheet As Microsoft.Office.Interop.Excel.Worksheet =
        Me.Application.Worksheets(1)
    Dim vstoWorksheet As Microsoft.Office.Tools.Excel.Worksheet =
            Globals.Factory.GetVstoObject(NativeWorksheet)
    DeselectedList = vstoWorksheet.Controls.AddListObject( _
        vstoWorksheet.Range("A1", "C4"), "DeselectedList")
End Sub

Sub List1_Deselected(ByVal Target As  _
    Microsoft.Office.Interop.Excel.Range) Handles DeselectedList.Deselected
    System.Windows.Forms.MessageBox.Show( _
        "The list object is no longer selected.")
End Sub

Remarks

This event is raised only when the ListObject control has focus, and then focus is transferred away from the ListObject control.