Where to place VBA coding?

[EssKayKay]

I have a question about location of VBA coding. The coding for my worksheet lies in two places, Sheet 1 and Module 1 (can’t answer why that happened). Should I or can I move all coding into one location (i.e. Module 1)?

Currently all routines are working fine so maybe “If it works don’t fix it” applies here. Your thoughts. . .

 

[Joe4]

A good rule of thumb is that you should put any event procedure code in the appropriate underlying module (the "Sheet" and "ThisWorkbook" modules). Note the "event procedure" code is VBA code that runs automatically, like "Worksheet_Change").

Then any procedure/function that you create and run manually (by button or going through the Macros menu) should be placed in a General module that you manually create.
That will ensure that it is available from anywhere in your workbook.

 

[EssKayKay]

Thank you Joe. I will look at moving things as you recommend.