How many lines of code can one module in VBA editor contain for Word or Excel?

Question

Hello everyone,

Just I want to ask How many lines of code can one module in VBA editor contain for Word or Excel and still works fine when executing code?

Answer 1

There is no specific limit on the number of lines in a module.

The total size of a code module should not exceed 64K (65536 characters) - beyond that, code will become unstable.

EDIT (info provided by Colin Riddington):

The 64K limit applies only to fixed or static data at module level, see also  
https://www.isladogs.co.uk/code-module-size-limits/index.html and
https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/fixed-or-static-data-can-t-be-larger-than-64k

Answer 2

There is no specific limit on the number of lines in a module.

The total size of a code module should not exceed 64K (65536 characters) - beyond that, code will become unstable.

Hi mister Hans,

Thank you so much for the information.