Insufficent resources to display a form
 

Not that I have experienced, but a lot of clutter can build up in a form
while it is being designed. Try exporting the form, removing it from your
project, then importing it back again to get rid of the rubbish. Or have a
look at Rob Bovey's codecleaner add-in.

Robin Hammond
www.enhanceddatasystems.com

"Lionel M Fridjhon" wrote in message
nk.net...
I have written a VBA program for Excel that has a fairly large userform
with
listboxes, text boxes, frames and labels, as well as a few command
buttons.
(about 100 counting all objects on the form)
When I show the form in Excel, or when I select the form in VBA, I get a
message that says there are insufficient resources to display properly.
Usually the system allows me to continue, but periodically it just
crashes,
and I have to reboot.
Is there a limit to the number of objects one can put on the form, and is
there a way to increase the resources?
This program is for a client, and I cannot have the program produce error
messages which are essentially meaningless to most users.

Lionel