Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 575
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not enough system resources to display completely bgkgmg Excel Discussion (Misc queries) 2 June 3rd 10 04:07 PM
System Does not have enough resources to display Aviral Sharma Excel Discussion (Misc queries) 0 March 6th 09 10:47 AM
Not enough system resources to display completely sb1920alk Excel Discussion (Misc queries) 0 December 20th 07 07:05 PM
Not enough resources to display completely brad Excel Discussion (Misc queries) 2 May 19th 07 02:29 AM
Not Enough System Resources To Display Completly Matt Excel Programming 0 January 15th 04 11:14 PM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"