Partager via

Handling Events

  • Article

Dernière modification : mardi 12 janvier 2010

S’applique à : Excel 2010 | Office 2010 | VBA | Visual Studio

Starting in Excel 2010, XLLs can receive events designed to manage the asynchronous function life cycle. The events are as follows:

  • CalculationEnded: Raised when Excel is finished calculating. After this event, you can free resources allocated during the calculation.

  • CalculationCanceled: Raised when the user interrupts the calculation. The XLL stops any asynchronous activities. Immediately following this event, the CalculationEnded event is raised.

To handle these events, the XLL uses the C API function xlEventRegister (traduction automatique).

Notes

CalculationEnded and CalculationCanceled are not raised during programmatic recalculation.