IN THIS CHAPTER
This chapter introduces you to Visual Basic for Applications —VBA— and provides an introduction to 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
♦ Information on using 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?