ChartSheet.MouseDown Event

Occurs when a mouse button is pressed when the pointer is over a Microsoft.Office.Tools.Excel.ChartSheet.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Event MouseDown As ChartEvents_MouseDownEventHandler

event ChartEvents_MouseDownEventHandler MouseDown

Examples

The following code example demonstrates a handler for the MouseDown event that displays a message box when the mouse is pressed while the pointer is over the current Microsoft.Office.Tools.Excel.ChartSheet. The example also uses the x and y parameters of the event handler to display the coordinates of the mouse pointer.

Private Sub DisplayMouseDown()
    Globals.Sheet1.Range("A1", "A5").Value2 = 22
    Globals.Sheet1.Range("B1", "B5").Value2 = 55

    Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
        Excel.XlRowCol.xlColumns)
    Me.ChartType = Excel.XlChartType.xl3DColumn
End Sub 

Sub ChartSheet1_MouseDown(ByVal Button As Integer, _
    ByVal Shift As Integer, ByVal x As Integer, _
    ByVal y As Integer) Handles Me.MouseDown

    MsgBox("The chart sheet was clicked at" & _
        " coordinates " & x.ToString() & ", " & y.ToString())
End Sub

private void DisplayMouseDown()
{
    Globals.Sheet1.Range["A1", "A5"].Value2 = 22;
    Globals.Sheet1.Range["B1", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DColumn;

    this.MouseDown +=
        new Excel.ChartEvents_MouseDownEventHandler(
        ChartSheet1_MouseDown);
}

void ChartSheet1_MouseDown(int Button, int Shift, int x, int y)
{
    MessageBox.Show("The chart sheet was clicked at" +
        " coordinates " + x.ToString() + ", " + y.ToString());
}

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

ChartSheet Interface

Microsoft.Office.Tools.Excel Namespace