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.
Index