Chapter 7: Introducing Visual Basic for Applications

 Download CD Content

Overview

In This Chapter

This chapter introduces you to Visual Basic for Applications (VBA) and the objects that make up Excel.

• An introduction to VBA - the programming language built into Excel

• How VBA differs from traditional spreadsheet macro languages and how it differs from the Visual Basic language

• How to use the Visual Basic Editor (VBE)

• How to work in the Code windows in the VBE and customize the VBE environment

• How to use Excel's macro recorder

• An overview of objects, collections, properties, and methods

• A case study of the Comment object

• Specific information and examples of working with Range objects

• How to access a lot of information about Excel objects, properties, and methods

Programming Excel essentially boils down to manipulating objects, which you do by writing instructions in a language that Excel can understand: VBA.