Size limit on Modules in VBA?

[mcomp72]

I'm nearing the completion of a macro-enabled workbook that has many modules. I remember seeing some forum posts online that talked about there being a size limit to modules. It seems that the unofficial word is that the limit is 64K for each one.

One post I saw suggested to type the following in the Intermediate window in each module.

?len(application.VBE.ActiveCodePane.CodeModule.Lines(1,application.VBE.ActiveCodePane.CodeModule.CountOfLines))/1000

This returns a number, and in a few instances, what it returns on my modules is higher than 64. One userform module is even over 100.

However, I have tested my workbook on a few different computers (running different versions of Excel) and everything seems to work fine. So, I'm wondering... should I still break up my modules that are apparently over 64 in size? Or am I okay if I am not receiving an error when using the file?

 

[Paul Ked]

https://docs.microsoft.com/en-us/dotnet/visual-basic/programming-guide/program-structure/limitations

 

[MARK858]

That article is referring to VB and not VBA.

 

[mcomp72]

Hi Paul. Thanks for this link. The page references VB.NET, but does not say anything about VBA. Is it understood within the VBA community that this also applies to VBA?

 

[MARK858]

I have never seen anything official, the best description I have seen is in the link below which is taken from Professional Excel Development by Rob Bovey, Stephen Bullen....

https://app.box.com/s/qne9ubx7ghrhoo6o3481z6esy7fohifb

 

[Paul Ked]

My apologies