You covered a significant number of topics concerning VBA programs in this chapter. The looping code structures (Do-Loop and For/Next) and variable arrays provide enormous power by allowing us to write more efficiently and significantly shorten the code.
You also examined a number of methods used for interaction with an Excel worksheet including input validation, entering formulas in spreadsheet cells, and using the Change() event procedure of a worksheet.
The Math Game used all of these tools plus a special method (OnTime()) of the application object to repeatedly call a procedure at a specified time interval.
You also examined the macro recorder and Forms toolbar controls.
The next chapter introduces the Excel object model concentrating on the objects at the top of the hierarchy. You have seen many examples of Excel objects in the first four chapters of this book. Now it is time to take an in depth look at these objects, their properties, and their methods.
Was this article helpful?