Chart.DragOver 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 a range of cells is dragged over a Chart control.
public:
event Microsoft::Office::Interop::Excel::ChartEvents_DragOverEventHandler ^ DragOver;event Microsoft.Office.Interop.Excel.ChartEvents_DragOverEventHandler DragOver;member this.DragOver : Microsoft.Office.Interop.Excel.ChartEvents_DragOverEventHandler Event DragOver As ChartEvents_DragOverEventHandler Event Type
Examples
The following code example creates a Chart with a handler for the DragOver event that displays a message box when a range of cells is dragged over the chart.
private void DisplayDragOver()
{
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.DragOver +=
new Excel.ChartEvents_DragOverEventHandler(
chart1_DragOver);
}
void chart1_DragOver()
{
MessageBox.Show("A range was dragged over the chart.");
}
WithEvents DragOverChart As Microsoft.Office.Tools.Excel.Chart
Private Sub DisplayDragOver()
Me.Range("A1", "A5").Value2 = 22
Me.Range("B1", "B5").Value2 = 55
DragOverChart = Me.Controls.AddChart(Me.Range("D2", "H12"), _
"DragOverChart")
DragOverChart.SetSourceData(Me.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
DragOverChart.ChartType = Excel.XlChartType.xl3DColumn
End Sub
Sub DragOverChart_DragOver() Handles DragOverChart.DragOver
MsgBox("A range was dragged over the chart.")
End Sub