Calculate Event

Microsoft Excel Visual Basic

Occurs after the chart plots new or changed data, for the Chart object. Occurs after the worksheet is recalculated, for the Worksheet object.

Private Sub object_Calculate()

object    Chart or Worksheet. For information about using events with the Chart object, see Using Events with the Chart Object.

Example

This example adjusts the size of columns A through F whenever the worksheet is recalculated.

Private Sub Worksheet_Calculate()
    Columns("A:F").AutoFit
End Sub