Working with VBA Sub Procedures


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, which perform tasks but do not return discrete values.

♦ Declaring and creating VBA Sub procedures

♦ Executing procedures

♦ Passing arguments to a procedure

♦ Using error-handling techniques

♦ An example of developing a useful procedure

VBA also supports Function procedures, which I discuss in Chapter 10.

Chapter 11 has many additional examples of procedures that you can incorporate into your work.

0 0

Post a comment