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

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace