Insufficent resources to display a form

  • Thread starter Thread starter Lionel M Fridjhon
  • Start date Start date
L

Lionel M Fridjhon

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
 
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
 
Back
Top