O'Reilly logo

Excel® 2007 Power Programming with VBA by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Introducing Visual Basic for Applications

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.

Some BASIC Background

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required