Each project can consist of a variety of different types of object and some objects even have two components, in the case of a userform, which has a code module associated with it.
Every project contains at least one node.
Microsoft Excel Objects - Contains a module for each worksheet and chart sheet as well a "ThisWorkbook" module.
Microsoft Word Objects - Contains a module for each ???
Microsoft PowerPoint Objects - Contains a module for each ???
Forms - Contains all the custom dialog boxes or userforms. Right mouse clicking on this node will allow you to select either the userform itself or the standard code module associated with it.
Modules - Contains all the standard code modules that contain the majority of your VBA code.
Classes - Contains all the class code modules that contain VBA code. This allows you to create your own objects with custom properties and methods.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext