Add a procedure to the VBA code library
A procedure you want to make available in the VBA code library need to be inside a module. If you already have a module with similar related procedures, you may add the procedure in there. Here I show how you can add the procedure making it part of a new module.
To add a procedure in your current project in a a new module in the VBA code library:
- In the Code Explorer right-click the procedure and select 'Add to library...';
- Chosing a location in the \VBA Code folder most suitable to store the procedure.
New Folder If there is no suitable location, feel free to create a new folder
in a logical location in the library hierarchy.
As you see in the image below the 'Add to library' feature tries to give a suitable name for the module using the procedure and prefixing it with 'mod'. After pressing Save the new module is created in the selected location containing the new procedure.
