Help required for newbie to understand VBA overall structure

[webcommerce]

Hello folks .. I am a new member of the forum,

I am new to VBA and seeking help to learn. Hopefully some guru here will take pity and answer what may seem to be a silly question.
This is a learning question: I want to hire some expert programmers to work on a project but want to keep each part separated for secrecy purposes.
Each programmer will have the parameters for the complete project but will see only their part.
Each part is complete in itself but shares common sheets and controls.

Are these code parts called modules, or is there another name for them?
I understand the code parts can be delivered in text files, but how would I combine them into the complete project?

I have hunted for some time to try and get some idea of this, without success.
Can anyone advise me, I would be most appreciative.
Thank you.

[6StringJazzer]

The code parts are modules. There are three types of modules:

Worksheet modules: These are code modules that are each associated with a specific worksheet. These exist by default for each worksheet.

Modules (I don't know what might be the proper name): These are standalone modules that are created by the developer. When created they get default names like Module1 but the names can be changed. Public Const and user-defined functions can only be defined in this type of module.

Class Modules: Define a class.

I have been a professional software developer and software development manager for 37 years. Defining a project of any significant size where the developers can't talk to each out of secrecy concerns other is a fool's errand. I don't have time to write a page about why this idea is doomed but I don't advise it. The idea of partitioned modules that share common sheets and controls is the final nail in the coffin. This is known as common environment coupling and is a bad idea to start with, and if you try to do this without letting developers interact it can't work at all.

[webcommerce]

Thank you very much for your kind and helpful advice. I apologise for the delay - I've been out of state for a while since making my question.

I had pretty much worked out for myself the dangers involved in the secrecy aspect I am now working with one developer only.

Again, my thanks ... I am learning.

[indecent43]

In Excel VBA, there are four main types of modules:

Standard Code Modules, which contain custom macros and functions,
Workbook And Sheet Code Modules, which contain event procedures for the workbook, and worksheets and chart sheets,
User Forms, which contain code for the controls on a UserForm object,
Class Modules, which contain Property Let, Get, and Set procedures for Objects that you create.

[webcommerce]

Thank you .. this is very clear and answers my questions fully. I appreciate your time.

[6StringJazzer]

indecent43 included Workbook and UserForm modules, which I had neglected to include. Workbook modules are intended for handling events that occur at the workbook level, and UserForm modules are the code behind UserForms.

[webcommerce]

Thank you for the clarification, appreciated.