Business solutions Automating Microsoft

4. Using Procedures

IN THIS CHAPTER

Understanding Procedure Types

Declaring Procedures as Public or Private

Passing Arguments

Giving a Function a Data Type

Implementing Error Handling

Debugging Code

Understanding Procedure Types

VBA code is organized into statements. A statement is a single line of code, for example:

intCount = 6

This statement sets the value of the intCount variable to 6. Although you can execute individual statements in the Immediate window, you can’t store individual statements in a VBA module. Within a module, statements must be organized into procedures: groups of statements that perform a task together. Although you’ve already seen a few procedures in the brief bits of code demonstrated in earlier chapters, this chapter ...