Is there a size limitation on how much code can be placed in a user form? I
am starting to get messages that appear to be out of memory erorrs.

Sorry, I couldn't resist.
On the subject line, "Some girls think so"
<G
"Greg Bloom" wrote in message
news:M7Ahb.81167$%h1.85926@sccrnsc02...
Is there a size limitation on how much code can be placed in a user form?
I
am starting to get messages that appear to be out of memory erorrs.

I suppose someone had to...

<g

P


"Don Guillett" wrote in message
...
Sorry, I couldn't resist.
On the subject line, "Some girls think so"
<G
"Greg Bloom" wrote in message
news:M7Ahb.81167$%h1.85926@sccrnsc02...
Is there a size limitation on how much code can be placed in a user
form?
I
am starting to get messages that appear to be out of memory erorrs.

Don Guillett wrote
Sorry, I couldn't resist.
On the subject line, "Some girls think so"

Most don't.


I think it matters - I am using a 15" monitor now cos my 21" one
died and I am a poor student. I was using a 21" for 6 years and
SIZE DOES MATTER.

Chrissy.

Generally, modules should be held to under 64K - at least that is the advice
I have seen given here.

--
Regards,
Tom Ogilvy

"Greg Bloom" wrote in message
news:M7Ahb.81167$%h1.85926@sccrnsc02...
Is there a size limitation on how much code can be placed in a user form?
I
am starting to get messages that appear to be out of memory erorrs.

How do I see how big a module is?

Chrissy.


Tom Ogilvy wrote
Generally, modules should be held to under 64K - at least that is the advice
I have seen given here.

--
Regards,
Tom Ogilvy

Greg Bloom wrote
Is there a size limitation on how much code can be placed in a user form?
I am starting to get messages that appear to be out of memory errors.

The only way I know to find the module size is to export it and then check the
size. I think that is the actual method used in

Excel Code Documenter
Developed by Rob Bovey, MCSE. The Excel 97 Code Documentor automatically documents
the "vital ... number of procedures, DLL declarations, module size and lines of ...
http://www.payneconsulting.com/payneconsultingold/ office/Excel/excelcodedocumenter.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chrissy" wrote in message ...
How do I see how big a module is?

Sorry that was an old link for Rob Bovey's use this one instead:

Excel VBA Code Documentor
http://www.appspro.com/utilities/Documentor.asp

The Excel 97 Code Documentor automatically documents the "vital statistics"
of your VBA project. These statistics include:
A complete procedure listing for all modules in an outlined worksheet
A summary of the number and type of VBComponents used in the project
The number of procedures in the project, both total and per VBComponent
The number of DLL declarations in the project, both total and per VBComponent
Total lines of code in the project and per VBComponent
Module file size for each code module

--

For keeping track of your Functions and Subroutines, I have
Sub ListFunctionsAndSubs()
'Documented in http://www.mvps.org/dmcritchie/excel/buildtoc.htm
'Coding: http://www.mvps.org/dmcritchie/excel/code/listfsubs.txt
will overwrite content of the worksheet it is run in, it will identify duplicate
subroutines and functions and which book they are in, along the the number
of code lines in each sub or function. The Workbooks that are
included in the documentation are the workbooks that are open when run.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David McRitchie" wrote in message ...
The only way I know to find the module size is to export it and then check the
size. I think that is the actual method used in

Excel Code Documenter
Developed by Rob Bovey, MCSE. The Excel 97 Code Documentor automatically documents
the "vital ... number of procedures, DLL declarations, module size and lines of ...
http://www.payneconsulting.com/payneconsultingold/ office/Excel/excelcodedocumenter.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chrissy" wrote in message ...
How do I see how big a module is?

I like that Documentor BUT ...... I want to document an XLA and, unless
I missed something, I don't think I can.

Another thing - does it would on Excel XP as I usually run that but do not
have it running now to test.

Chrissy.

David McRitchie wrote
Sorry that was an old link for Rob Bovey's use this one instead:

Excel VBA Code Documentor
http://www.appspro.com/utilities/Documentor.asp

The Excel 97 Code Documentor automatically documents the "vital statistics"
of your VBA project. These statistics include:
A complete procedure listing for all modules in an outlined worksheet
A summary of the number and type of VBComponents used in the project
The number of procedures in the project, both total and per VBComponent
The number of DLL declarations in the project, both total and per VBComponent
Total lines of code in the project and per VBComponent
Module file size for each code module