Macro Modules

[Loopy86]

At the risk of sounding stupid......

Are Modules like chapters?
Should I write all of my code in one module or space it out?

 

[JamesW]

Hi,

Some interesting reads here:

http://www.cpearson.com/excel/codemods.htm
http://www.emagenit.com/VBA%20Folder/what_is_a_vba_module.htm
http://www.google.com/#sclient=psy&...x=1&bav=on.2,or.r_gc.r_pw.&fp=d8193e5b46b6707

I guess you could call them chapters. Common practice is to seperate your code into different modules to make it easier to debug and follow.

 

[bertie]

There is no such thing as a stupid question. I can't offer the same guarantee for my answer.

Chapters you read one after the other. Modules don't work that way.

If you have a large project it makes editing and debugging easier if you modularise your code.

For example:
The MENU module could store code for menus
The TOOLS module could store functions.
The MAIN module could be the main code page.

The code in the MAIN module calls procedures in MENU and TOOLS when needed.

You could of course place all your code within one module. It depends how far you are prepared to scroll down to find what you are looking for.