Finally the aim of this tutorial is also to obtain a single module and make ... their Caption will be displayed in the code of the calling function. Create a class module in your VBA project, name it ...

You can even create your own specialized .NET class libraries and reference them from within Excel's VBA code editor ... refer to that name in your Excel module.

And, as long as I'm here, class modules are for creating your own programatic (code-only, no UI) objects -- the ADO data access objects are an example of that kind of object. User forms ...