Understanding Chart Events : Chart Event « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Chart Event

Understanding Chart Events

 
Private Sub Chart_Activate()
    msg = "Hello " & Application.userName & vbCrLf & vbCrLf
    msg = msg & "You are now viewing the six-month sales "
    msg = msg & "summary for Products 1-3." & vbCrLf & vbCrLf
    msg = msg & "Click on items in the chart to find out what they are."
    MsgBox msg, vbInformation, ActiveWorkbook.name
End Sub








Related examples in the same category

1.Chart_Deactivate procedure also displays a message only when the chart sheet is deactivated:
2.The Chart_Select procedure listed next is executed whenever an item on the chart is selected:
3.Events with Chart Sheets
4.Events with Embedded Charts
5.Chart double click event
6.hides the legend when it is double-clicked; double-clicking either axis brings back the legend:
7.zooms in on a left mouse click and zooms out on a right mouse click.
8.Embedded Chart Mouse Events