ChartEvents_BeforeDoubleClickEventHandler Delegate
A Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)
Usage
Sub Sub1(ElementID As Integer, _
Arg1 As Integer, _
Arg2 As Integer, _
Cancel As Boolean)
End Sub
Dim chartEvents_BeforeDoubleClickEventHandler1 As New ChartEvents_BeforeDoubleClickEventHandler(AddressOf Sub1)
Syntax
Public Delegate Sub ChartEvents_BeforeDoubleClickEventHandler( _
<InAttribute()> ByVal ElementID As Integer, _
<InAttribute()> ByVal Arg1 As Integer, _
<InAttribute()> ByVal Arg2 As Integer, _
<InAttribute(), OutAttribute()> ByRef Cancel As Boolean _
)
public delegate void ChartEvents_BeforeDoubleClickEventHandler(
[In] int ElementID,
[In] int Arg1,
[In] int Arg2,
[In, Out] ref bool Cancel
);
public delegate Void ChartEvents_BeforeDoubleClickEventHandler(
Int32 ElementID,
Int32 Arg1,
Int32 Arg2,
&Boolean Cancel
);
public delegate void ChartEvents_BeforeDoubleClickEventHandler(
/*in*/int ElementID,
/*in*/int Arg1,
/*in*/int Arg2,
/*in*/boolean Cancel
);
In JScript, you can use the delegates in the .NET Framework, but you cannot define your own.
Parameters
- ElementID
Required. The double-clicked object.
- Arg1
Depends on ElementID.
- Arg2
Depends on ElementID.
- Cancel
Optional. False when the event occurs. If the event procedure sets this argument to True, the default double-click action isn't performed when the procedure is finished.
Remarks
The following table shows the arguments associated with each ElementID.
ElementID |
Arg1 |
Arg2 |
xlAxis |
AxisIndex |
AxisType |
xlAxisTitle |
AxisIndex |
AxisType |
xlDisplayUnitLabel |
AxisIndex |
AxisType |
xlMajorGridlines |
AxisIndex |
AxisType |
xlMinorGridlines |
AxisIndex |
AxisType |
xlPivotChartDropZone |
DropZoneType |
None |
xlPivotChartFieldButton |
DropZoneType |
PivotFieldIndex |
xlDownBars |
GroupIndex |
None |
xlDropLines |
GroupIndex |
None |
xlHiLoLines |
GroupIndex |
None |
xlRadarAxisLabels |
GroupIndex |
None |
xlSeriesLines |
GroupIndex |
None |
xlUpBars |
GroupIndex |
None |
xlChartArea |
None |
None |
xlChartTitle |
None |
None |
xlCorners |
None |
None |
xlDataTable |
None |
None |
xlFloor |
None |
None |
xlLegend |
None |
None |
xlNothing |
None |
None |
xlPlotArea |
None |
None |
xlWalls |
None |
None |
xlDataLabel |
SeriesIndex |
PointIndex |
xlErrorBars |
SeriesIndex |
None |
xlLegendEntry |
SeriesIndex |
None |
xlLegendKey |
SeriesIndex |
None |
xlSeries |
SeriesIndex |
PointIndex |
xlTrendline |
SeriesIndex |
TrendLineIndex |
xlXErrorBars |
SeriesIndex |
None |
xlYErrorBars |
SeriesIndex |
None |
xlShape |
ShapeIndex |
None |
The following table describes the meaning of the arguments.
Argument |
Description |
AxisIndex |
Specifies whether the axis is primary or secondary. Can be one of the following XlAxisGroup constants: xlPrimary or xlSecondary. |
AxisType |
Specifies the axis type. Can be one of the following XlAxisType constants: xlCategory, xlSeriesAxis, or xlValue. |
DropZoneType |
Specifies the drop zone type: column, data, page, or row field. Can be one of the following XlPivotFieldOrientation constants: xlColumnField, xlDataField, xlPageField, or xlRowField. The column and row field constants specify the series and category fields, respectively. |
GroupIndex |
Specifies the offset within the ChartGroups collection for a specific chart group. |
PivotFieldIndex |
Specifies the offset within the PivotFields collection for a specific column (series), data, page, or row (category) field. |
PointIndex |
Specifies the offset within the Points collection for a specific point within a series. The value –1 indicates that all data points are selected. |
SeriesIndex |
Specifies the offset within the Series collection for a specific series. |
ShapeIndex |
Specifies the offset within the Shapes collection for a specific shape. |
TrendlineIndex |
Specifies the offset within the Trendlines collection for a specific trendline within a series. |
The DoubleClick method doesn't cause this event to occur.
This event doesn't occur when the user double-clicks the border of a cell.
Platforms
Development Platforms
Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000