Hello,
Is there a limit to the number of forms you can have in an Excel workbook?
Or, what limits the number of forms and modules?

Thanks,

Bill

There are no hard limits to the number of forms of modules. The
only limit would be available memory. I've written applications
with dozens of forms and dozens of modules with no problems. I do
periodically run Rob Bovey's Code Cleaner add-in to keep excess
garbage VBA byte code from accumulating.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Bill" wrote in message
nk.net...
Hello,
Is there a limit to the number of forms you can have in an
Excel workbook? Or, what limits the number of forms and
modules?

Thanks,

Bill

Where can I find Rob Bovey's Code Cleaner add-in?

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

http://www.appspro.com/Utilities/CodeCleaner.htm

Bill wrote:

Where can I find Rob Bovey's Code Cleaner add-in?

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info