Resize Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when the chart is resized.

Private Subobject**_Resize()**

objectChart or an object of type Chart declared with events. For more information, see Using Events with Embedded Charts.

Remarks

You must first set the SizeWithWindow property to True before using this event with a chart sheet.

Example

This example keeps the upper-left corner of the chart at the same location when the chart is resized.

Private Sub myChartClass_Resize()
    With ActiveChart.Parent
        .Left = 100
        .Top = 150
    End With
End Sub

Applies to | Chart Object