Chapter 9: Working with VBA Sub Procedures

 Download CD Content

Overview

In This Chapter

A procedure holds a group of Visual Basic for Applications (VBA) statements that accomplishes a desired task. Most VBA code is contained in procedures. This chapter focuses on Sub procedures.

• Declaring and creating VBA Sub procedures

• Executing procedures

• Passing arguments to a procedure

• Using error-handling techniques

• An example of developing a useful procedure

CROSS-REFERENCE  

VBA also supports Function procedures, which I discuss in Chapter 10. Chapter 11 has many additional examples of procedures, both Sub and Function , that you can incorporate into your work.