Introducing Visual Basic for Applications


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.

0 0

Post a comment