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" <bill@bpiconsulting.com> wrote in message
news:Jvvbf.6184$AS6.694@newsread3.news.atl.earthlink.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
>