modules vs code within sheets

[andyjames]

can someone tell me what the benefit to having multiple modules is and on top of this what is the benefit of putting code within a module and not just behind the worksheet?

 

[Norie]

andy

Well having multiple modules is really only an organisational thing and is usually just down to personal preference.

As to code in worksheet modules, that should normally be only code pertaining to that particular worksheet, normally event code such as Worksheet_Change.

There are other considerations about where you locate code, for example the scope of variables.

 

[SydneyGeek]

As Norie said, general code modules and worksheet / workbook modules are not the same thing.

Use a worksheet module for:
Code that needs to respond to events like changing a cell value or moving to another cell / range

Use the workbook module for:
Code that responds to global things like opening, closing, printing or saving a workbook

Use general modules for:
Everything else

Denis