ActiveSheetChanged Event (GcSpreadSheet)

Occurs when the user has changed the active sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Event ActiveSheetChanged As System.EventHandler

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler
 
AddHandler instance.ActiveSheetChanged, handler

public event System.EventHandler ActiveSheetChanged

This example uses the ActiveSheetChanged event.

gcSpreadSheet1.SheetCount = 2;

private void gcSpreadSheet1_ActiveSheetChanged(object sender, EventArgs e)
        {
            listBox1.Items.Add("ActiveSheetChanged");
        }

private void gcSpreadSheet1_ActiveSheetChanging(object sender, System.ComponentModel.CancelEventArgs e)
        {
            listBox1.Items.Add("ActiveSheetChanging");            
        }

VB.NET

GcSpreadSheet1.SheetCount = 2

Private Sub GcSpreadSheet1_ActiveSheetChanged(sender As System.Object, e As System.EventArgs) Handles GcSpreadSheet1.ActiveSheetChanged
        ListBox1.Items.Add("ActiveSheetChanged")
    End Sub

    Private Sub GcSpreadSheet1_ActiveSheetChanging(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles GcSpreadSheet1.ActiveSheetChanging
        ListBox1.Items.Add("ActiveSheetChanging")
    End Sub

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GcSpreadSheet Class
GcSpreadSheet Members