Spread Windows Forms 11.0 Product Documentation
ActiveSheetChanged Event
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : ActiveSheetChanged Event
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

Reference

FpSpread Class
FpSpread Members