ComboBox Triggering Resourse Warning

P

Phil Hageman

When the arrow in ComboBox1 on Sheet1 is clicked , a warning message comes up: “Not enough system resources to display completely.†The ComboBox has the following properties
LinkedCell: Sheet2!$B$10; ListFillRange: Sheet2!$C$10:$C$1

The following formula correctly populates merged cell range M7:AX7 on Sheet1 – in response to the user’s choice from ComboBox1
=OFFSET(Sheet2!D9,MATCH(Sheet2!B10,{"T1","T2","R1","R2","R3","R4"},0),0

However, clicking “OK†in the message box does not remove the message box – but going to Sheet2 and then back to Sheet1 clears the message box. It’s as though the original appearance of the message box does not do a screen refresh by simply clicking the “OK†button

Can someone advise me on the source of the error message, and how to remove the cause? This error is the only thing going wrong in this workbook - as well as any other (MS Office) application

Thanks
Phi
 
T

Township of East Hanover

I'm guessing that this is Win9X or WinMe. If it is then your system is
running out a memory pool called windows resources which goes to displaying
controls on the screen..... you can either switch to WinXP or Win2K or try
and reduce the number of applications running at the time. Remember that
every icon on the system tray is an application running.... This can also be
caused by some application that doesn't release all resources when it is
closed....


Phil Hageman said:
When the arrow in ComboBox1 on Sheet1 is clicked , a warning message comes
Click to expand...
up: "Not enough system resources to display completely." The ComboBox has
the following properties:
LinkedCell: Sheet2!$B$10; ListFillRange: Sheet2!$C$10:$C$15

The following formula correctly populates merged cell range M7:AX7 on
Click to expand...
Sheet1 - in response to the user's choice from ComboBox1:
=OFFSET(Sheet2!D9,MATCH(Sheet2!B10,{"T1","T2","R1","R2","R3","R4"},0),0)

However, clicking "OK" in the message box does not remove the message
Click to expand...
box - but going to Sheet2 and then back to Sheet1 clears the message box.
It's as though the original appearance of the message box does not do a
screen refresh by simply clicking the "OK" button.
Can someone advise me on the source of the error message, and how to
Click to expand...
remove the cause? This error is the only thing going wrong in this
workbook - as well as any other (MS Office) application.
 
T

thessels

Hi there,

I also encountered this problem, with a combobox filled with dat
coming from another worksheet. This seems to be an old Excel-bug
already known in Excel-95 and 97, but I find it in Excel 2k too
working with W2k. It has to do with the combination of using
combobox, using links to another worksheet, and not having the sam
zoom-settings! Set zoom to 100% and the problem is solved.

See Microsoft Knowledge Base KB183503 a
http://support.microsoft.com/default.aspx?scid=kb;en-us;183503 fo
details.

Thijs
 
Top