"Not enough system resources to display completely"

[Guest]

I get the following message in Excel when attempting to use a ComboBox
pulldown:
"Not enough system resources to display completely"
even though it used to work fine and I've restarted several times.

Somewhere along the line something has creeped into my file and/or macros to
make this happen to all of my ComboBoxes.

Anyone have any idea?

Thanks

 

[Oliver Ferns via OfficeKB.com]

Hi,
Is the source data for the combobox held on a different worksheet? If so,
is the zoom on the source worksheet different to that of the sheet that
holds the combobox? If so, I believe this is the problem, although it would
help if you posted version information. Try setting the zoom levels on both
sheets to the same value and see if this fixes your problem..


Hth,
Oli