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?

0 0

Post a comment