Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Learning VBA Basics
Learning
VBA Basics
This topic’s approach to Excel 2010 consists
mostly of examining the features and
settings found in some of the relatively
obscure and hard-to-find sections of the
Excel interface. However, there are things
you can make Excel do that are not
available through the program’s interface.
How? By programming them using the
Visual Basic for Applications (VBA)
programming language that comes with
Excel. You use VBA to build small sets of
instructions called macros . With these
instructions, you can make Excel perform
multiple tasks in a single operation or
perform tasks that you cannot access
through the interface.
VBA is a large and complex topic, so in this
chapter, you will not learn how to program
in VBA. (If you are interested in learning
VBA, see the Wiley book VBA for
Dummies .) Instead, you will learn how to
record your own macros and work with
macros that you have obtained from other
sources, such as the VBA macro examples
used throughout this topic. For these kinds
of macros you will learn how to add a
macro to a module using the VBA Editor,
and you will learn various ways to run a
macro.
 
Search JabSto ::




Custom Search