System Resources
 

I've developed a fairly large workbook in excel that has
about 8 worksheets and about 10 userforms. The largest
userform (about 97 activeX controls on the userform) is
now giving me trouble. Specifically, when I click on
almost any of the combo boxes, I get the following
message in an excel message box: "Not enough system
resources to display completely."

I am working on a Dell Pentium 4, 2.4 mhz machine with
512k ram.

Any help on this issue is greatly appreciated

Frank

System Resources
 

Unfortunately, this is a long-standing problem with ComboBoxes. On
worksheets you can generally fix the problem by adjusting the zoom factor. I
don't know of a solution for UserForms. I would suggest, though, that 97
ActiveX controls on a single UserForm is asking for trouble.

--

Vasant

"Frank" wrote in message
...
I've developed a fairly large workbook in excel that has
about 8 worksheets and about 10 userforms. The largest
userform (about 97 activeX controls on the userform) is
now giving me trouble. Specifically, when I click on
almost any of the combo boxes, I get the following
message in an excel message box: "Not enough system
resources to display completely."

I am working on a Dell Pentium 4, 2.4 mhz machine with
512k ram.

Any help on this issue is greatly appreciated

Frank

System Resources
 

On Tue, 25 Nov 2003 19:03:45 -0800, "Frank" wrote:

"Not enough system
resources to display completely."

I am working on a Dell Pentium 4, 2.4 mhz machine with
512k ram.

Any help on this issue is greatly appreciated

Frank

I enclose below a quote from Ron Martell(MS MVP Windows) regarding "system
resources". Makes for some enlightening reading.....Resources vs RAM.

HTH Gord Dibben XL2002

***Start Ron Martell Quote***

System Resources refers to two 64K blocks of memory that Windows
allocates to programs for tracking purposes. These blocks are called
User Resources and GDI Resources respectively and Windows reports
whichever has the least available free space as the value for "Free
System Resources".

The value of Free System Resources should not be a concern unless and
until you start getting "System Resources are getting low" type
warning messages, which generally happens at about the 10% level. In
test circumstances it has been shown possible for a computer to
operate at full performance with System Resources showing zero percent
free.

System Resources are totally unrelated to the amount of RAM installed
in your computer and adding more RAM will not affect the System
Resources (unless you start running more applications because you have
more RAM).

System Resource usage is determined by the number and type of
applications that you have running on the computer. Certain types of
applications have been shown to be especially demanding in terms of
System Resource usage:
- "Eye and Ear Candy" such as Active Desktop View As Web Page,
sound effect schemes, animated mouse cursors and desktop icons, and
fancy screen savers.
- Web browsers, as each open browser window requires additional
resources.
- Multimedia applications of all types
- System monitoring utilities such as Norton SystemWorks.

If you are running any 16 bit applications (DOS or Windows 3.x) then
Windows 95/98 will treat the System Resources allocated to all of
these applications as one block and will not release any of them for
reuse unless and until all of the open 16 bit applications have been
closed.

Also, when an application is loaded it is quite common that it will
also require some additional Windows components to be loaded as well.
However, when that application is closed Windows will, by design,
retain the Windows components because they are likely to be needed
again. Therefore the resources initially allocated when an
application is opened will not all be released when that application
is closed. Most, but not all.

Hope this explains the situation.

Good luck.

Ron Martell Duncan B.C. Canada

***End Ron Martell Quote***