VBA Building Blocks

In the previous chapter, you learned how to insert an empty module into a VBA project. A module is a container for your code and discrete sections of code are called procedures. For simple projects, you may only have a single module containing one or more procedures. As your projects become more complex, you'll have many modules. One of the benefits of using multiple modules is that it allows you to group related procedures together.

For the purposes of this discussion, you'll also become familiar with two types of procedures: subroutines and functions. Modules, subroutines and functions are the building blocks of a VBA project.

0 0

Post a comment