Within the last day or so Rob Bovey replied to an OP
and included the comment that (sic) "a module should
not exceed 64kb" ( I think that's what was said).

Would someone be kind enough to explain the reasons
behind this advice, please?

Would this apply to all modules (Standard, Class etc),
and would this equally apply to AddIns?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

Does the same apply to Userforms?
Just exported one and the .frm file is 90 Kb and the .frx file is 80 Kb.
It does actually sometimes show minor abberations, but sofar nothing major
to worry about.

RBS


"Stuart" wrote in message
...
Within the last day or so Rob Bovey replied to an OP
and included the comment that (sic) "a module should
not exceed 64kb" ( I think that's what was said).

Would someone be kind enough to explain the reasons
behind this advice, please?

Would this apply to all modules (Standard, Class etc),
and would this equally apply to AddIns?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

"RB Smissaert" wrote in message
...
Does the same apply to Userforms?
Just exported one and the .frm file is 90 Kb and the .frx file is 80 Kb.
It does actually sometimes show minor abberations, but sofar nothing major
to worry about.

That's a very good question. UserForms didn't even exist when this
problem first appeared, so I don't know if they are handled differently from
standard modules or not. I keep my own UserForm code within the 64KB limit
out of habit, so I haven't had the opportunity to test the size limit with
them. Based on postings here, having too many controls on a UserForm seems
to be a much more common problem then having to much code in them.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *