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.
Was this article helpful?