When to code in the different modules

[Excel_vba]

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?