Wiley Excel 2007 VBA Programming For Dummies 978-0-470-04674-6 ユーザーズマニュアル

In This Chapter

Gaining a conceptual overview of VBA

Finding out what you can do with VBA

Discovering the advantages and disadvantages of using VBA

Taking a mini-lesson on the history of Excel

T

his chapter is completely devoid of any hands-on training material. It
does, however, contain some essential background information that

assists you in becoming an Excel programmer. In other words, this chapter
paves the way for everything else that follows and gives you a feel for how
Excel programming fits into the overall scheme of the universe.

Okay, So What Is VBA?

VBA, which stands for Visual Basic for Applications, is a programming lan-
guage developed by Microsoft — you know, the company that’s run by the
richest man in the world. Excel, along with the other members of Microsoft
Office 2007, includes the VBA language (at no extra charge). In a nutshell,
VBA is the tool that people like you and me use to develop programs that
control Excel. 

Imagine an intelligent robot that knows all about Excel. This robot can read
instructions, and it can also operate Excel very fast and accurately. When you
want the robot to do something in Excel, you write up a set of robot instruc-
tions by using special codes. Tell the robot to follow your instructions, while
you sit back and drink a glass of lemonade. That’s kind of what VBA is all
about — a code language for robots. Note, however, that Excel does not come
with a robot or lemonade.

05_046746 ch01.qxp  1/12/07  6:16 PM  Page 11