Chart.ActivateEvent Event
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Occurs when the Chart control is activated.
public:
event Microsoft::Office::Interop::Excel::ChartEvents_ActivateEventHandler ^ ActivateEvent;event Microsoft.Office.Interop.Excel.ChartEvents_ActivateEventHandler ActivateEvent;member this.ActivateEvent : Microsoft.Office.Interop.Excel.ChartEvents_ActivateEventHandler Event ActivateEvent As ChartEvents_ActivateEventHandler Event Type
Examples
The following code example creates a Chart with a handler for the ActivateEvent event that displays a message box when the chart is activated.
private void DisplayWhenActivated()
{
this.Range["A1", "A5"].Value2 = 22;
this.Range["B1", "B5"].Value2 = 55;
Microsoft.Office.Tools.Excel.Chart chart1 =
this.Controls.AddChart(this.Range["D2", "H12"],
"chart1");
chart1.SetSourceData(this.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
chart1.ChartType = Excel.XlChartType.xl3DColumn;
chart1.ActivateEvent +=
new Excel.ChartEvents_ActivateEventHandler(
chart1_ActivateEvent);
}
void chart1_ActivateEvent()
{
MessageBox.Show("The chart was activated.");
}
WithEvents ActivateChart As Microsoft.Office.Tools.Excel.Chart
Private Sub DisplayWhenActivated()
Me.Range("A1", "A5").Value2 = 22
Me.Range("B1", "B5").Value2 = 55
ActivateChart = Me.Controls.AddChart(Me.Range("D2", "H12"), _
"ActivateChart")
ActivateChart.SetSourceData(Me.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
ActivateChart.ChartType = Excel.XlChartType.xl3DColumn
End Sub
Sub ActivateChart_ActivateEvent() Handles ActivateChart.ActivateEvent
MsgBox("The chart was activated.")
End Sub