Search notes:

VBA modules

A VBA module is the fundamental unit of VBA source code.

A module is part of a VBA project.

A module consists of a

header (name value pairs that describe linguistic characteristics of a module, so called attributes, usually machine generated)
body (source code)

Two kinds of modules:

Procedural modules
class modules

But see also object modules.

See also

In the Visual Basic Add-in Model, a VBA module is represented by a vbComponent object.

The 00_ModuleLoader allows to dynamically load modules from within VBA source code.

This example demonstrates how it is possible to create a dynamic VBA module, place a sub into it and then call it using Excel's application.run function.