Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / ActiveSheetChanged Event
Example


In This Topic
    ActiveSheetChanged Event
    In This Topic
    Occurs when the user has changed the active sheet.
    Syntax
    'Declaration
     
    Public Event ActiveSheetChanged As EventHandler
    'Usage
     
    Dim instance As FpSpread
    Dim handler As EventHandler
     
    AddHandler instance.ActiveSheetChanged, handler
    public event EventHandler ActiveSheetChanged
    Remarks
    This event is raised by the OnActiveSheetChanged method when the user has changed the active sheet.
    Example
    This example raises the event when the user clicks on another sheet.
    fpSpread1.Sheets.Count = 3;
    fpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always;
    
    private void fpSpread1_ActiveSheetChanged(object sender, System.EventArgs e)
    {
         ListBox1.Items.Add("Active Sheet Changed.");
    }
    FpSpread1.Sheets.Count = 3
    FpSpread1.TabStripPolicy = FarPoint.Win.Spread.TabStripPolicy.Always
    
    Private Sub FpSpread1_ActiveSheetChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FpSpread1.ActiveSheetChanged
         ListBox1.Items.Add("Active Sheet Changed.")
    End Sub
    See Also