View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default separate modules for each sub routine?

The hearsay is that modules shouldn't exceed 64K. This can be checked by
exporting the module as a bas file and then check the file size.

--
Regards,
Tom Ogilvy


"gocush" /delete wrote in message
...
The only technical limitation that I am aware of:
the first project I ever wrote I put all code in a single module. At some
point it started crashing. I was advised that problems can occur with

very
large modules.

After breaking up the code into logical sections the problem disappeared.
Whether this was due to reducing the module size or perhaps I modified the
code in the process I cant be sure. Just speculation and hearsay.

"smokiibear" wrote:

I'm looking for feedback on whether or not to create separate modules

for
each sub-routine and function, or to combine them in them in single

modules
(where it makes sense). I realize this may be like asking what is the
"best" flavor of ice cream, but I'm curious to hear what reasons people
have for their preference on this matter.

Thanks for your interest and opinions.

Smokii