Module Questions

[LNG2013]

Hello,

I have several different macro codes that do different things, currently they are all in one module. Should I be using a different module for each one of these?

What benefit does it have to use different modules?

Do I need to set each Module to Auto_Run in order for them all to run, if I were to break them up into seperate modules.

 

[swaink]

Hi LNG2013

Welcome to the board

I am sure many here have a preference but I find it cleaner and tidier to have multiple modules, once you have your macro's set you can then run them in the order you wish from one further macro as the example below

Sub runmymacros()
macro1
macro2
macro3
etc
etc
end sub

 

[LNG2013]

Thanks Swaink! I really appreciate your feedback! A technical question though, does using seperate modules allow me to use the same variables. Like currently in my coding I have about 9-10 seperate scripts all have different variables like x, y, z.

Hi LNG2013

Welcome to the board

I am sure many here have a preference but I find it cleaner and tidier to have multiple modules, once you have your macro's set you can then run them in the order you wish from one further macro as the example below

Sub runmymacros()
macro1
macro2
macro3
etc
etc
end sub

 

[swaink]

Hi LNG2013

Take a look at this link this is a well known and respected individual on this site which may be of help to you

http://www.cpearson.com/excel/DeclaringVariables.aspx

Kevin