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
Specific information and examples of working with
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.
Many hard-core programmers scoff at the idea of programming in BASIC. The name itself (an acronym for Beginner’s All-purpose Symbolic Instruction Code) suggests that it’s not a professional language. In fact, BASIC was first developed in the early 1960s as a way to teach programming techniques to college students. BASIC caught on quickly and is available in hundreds of dialects for many types of computers.
BASIC has evolved and improved over the years. For example, in many early implementations, BASIC was an interpreted language. Each line was interpreted before it was executed, causing slow performance. ...