When to code in the different modules

In the VBA Editor, there are 3 types of modules (I think that is the term) where you can write your code.


1. There is a module for each worksheet tab
2. There is a module called "ThisWorkbook"
3. Under the folder called "Modules" you can insert new modules.

----------------------------------------------------------------------------------------------------

Please answer each question:

1. How do you know when to use each type of module?
2. When is it best to use each module?
3. Are these modules there to divide up your code into logical blocks to improve understanding and readability for anybody who may need to review your code?

There are 2 types of modules, Objects (which include things like ThisWorkbook, Sheets, Userforms and Classes) and standard modules.

Objects contain code that relates to them and they can respond to events, so they contain subroutines that run when events fire, like a selection changing in a sheet, or the worksheet changing in a workbook, or a control on a userform etc....

Modules are simply containers for code; so your code will go in here unless it relates to a particular object.