Summary

In this chapter, you have seen some useful examples of how to utilize event procedures to respond to user actions.

You have been introduced to worksheet, chart, and workbook events, delving a little deeper into the following events:

□ Worksheet_Calculate

□ Chart_BeforeDoubleClick

□ Workbook_BeforeClose

□ Workbook_BeforePrint

VBA is essentially an event-driven language, so a good knowledge of the events at your disposal can open up a whole new world of functionality you never knew existed.

To find out more, have a play with the Object Browser, and consult the object model in Appendix A.

0 0

Post a comment