VBA code in sheets vs. modules

[MetLife]

Hi,

I just had a general question as to why some people put code in worksheet object instead of "modules"?

I don't like it when the code is located in the sheets because it makes it difficult to find.

Thanks

 

[RoryA]

Worksheet event code has to be in either the module for that sheet, or the ThisWorkbook module if it's the same for more than one sheet. Event code for ActiveX controls must be in the sheet module. Other code should generally be in a normal module, though if it relates specifically to one sheet you can certainly make a case for it being in that sheet's code module.

 

[MetLife]

Thanks for the explanation Rory!