Modules Management

[Kaye]

Hi,

I'm building a workbook with a number of macros that have been, in the main,
"recorded".

Is it good practice to keep all macros in the one Module? Is there any
advantage to keeping them in different modules?

Using the Record Macro feature ends up slipping each new macro into new
modules.

Thanks

 

[Frank Kabel]

Hi
though this is in most cases also a personal preference I
like to group my macros in several modules 8note: there's
a maximum of lines for one module).

So for example I use one module for general helper
functions/subs, one module for user interaction, etc.

Try arraing them in such a way that's easier for you to
maintain the code

 

[hglamy]

Great contribution, Frank !

hglamy

Hi
though this is in most cases also a personal preference I
like to group my macros in several modules 8note: there's
a maximum of lines for one module).

So for example I use one module for general helper
functions/subs, one module for user interaction, etc.

Try arraing them in such a way that's easier for you to
maintain the code

 

[Kaye]

Thanks Frank!