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 users 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. Its 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

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" wrote in message
...
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$15

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,
Phil

Thanks - I'll look deeper into it...

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...b;en-us;183503 fo
details.

Thijs

--
Message posted from http://www.ExcelForum.com