Thread: Module Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Module Question

Yes there is a limit to the size of a module, but I do not remember what it
is. That being said it is good practice to not make your modules too big. Far
too difficult to debug. Each module should do it's own set of tasks. For
example perhaps you will want to put all of your sorting routines in one
module and all of your printing routines in another. That makes debugging
much easier. You can change the names of your module by changing the name in
the properties window (F4 in the VBE).
--
HTH...

Jim Thomlinson


"Les" wrote:

As i am not a programmer i do not know if there is a limit to the length of a
module or ist it not good practise to have it too long/big ??
--
Les