Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
Overview
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.