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