Which Module Macros are Going?

[oskar44]

On the same workbook, sometimes my macros are going into the same module and sometimes in different modules. I have no problem with either method but I would prefer to keep all macros in the same module so I know where all macros are.

Now I have 6 modules in my VBA explorer and when I want to find (edit) a macro I have to click each module to see where my macro is.

Is there a way to have all macros in the same module and if not is it a good practice to copy / paste a macro from one module to another?

[Parth007]

Either you can club the code from all module & make it fit to run in one module or simply call them in one module.. may be..
Not sure.. experts would give appropriate assistance

[jaslake]

Hi Nicolas

In general you can place all your Code in the same General Module unless it's Sheet specific Code in which case it'll go in the Sheet Module.

However, if my Project contains a multitude of Macros, I like to use a Naming Convention for my General Modules such that the Name of the Module tells me what the Code is doing (don't use the same Name as the Code is called)...

Module Naming Convention.jpg

[oskar44]

That looks good John but how do I give a new name to a module and the subsequent ones?

Regarding your codes they all working very well and I have no issues ans as far as I know I have marked these threads as "Solved"

[jaslake]

Hi Nicolas

Go into VBA (Alt + F11)
Click on View ---> Properties Window
Select a Module
Change the Name
View.jpg Change Name.jpg

[oskar44]

It is so easy, thanks John.

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.