Microsoft® Office Excel 2003 Programming Inside Out

Chapter 3. Exploring Visual Basic for Applications

An Overview of Object-Oriented Programming

Working with Macros

This chapter provides an overview of how macros work in the context of Microsoft Office Excel 2003. The second part of the chapter covers macro recording and other related topics, but the first part steps back and gives you some perspective on what is happening when you create a macro. The quick version of that story is that Visual Basic for Applications (VBA) sees Excel as a series of objects that have attributes to describe them and actions those objects "know" how to take. Chapter 1, "What’s New in Microsoft Office Excel 2003," showed you some of the basic elements you’ll encounter when using and programming Excel; this chapter ...