Resize Event

Microsoft Excel Visual Basic

Occurs when the chart is resized.

Private Sub object_Resize()

object    Chart or an object of type Chart declared with events in a class module. For more information, see Using Events with Embedded Charts.

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