Featured Product

Excel Daily News

Combo Box

Even when I have nothing else open, when I put a combo box into my spreadsheet and try to select a name from it, I get the "Not enough resources to display completely" message. Does anyone know why?

Posted by Kevin James on May 01, 2001 3:28 PM

Tim:

I kept waiting to see if anyone else would respond before I threw my 2 cents worth in the pool. (It seems after I sent a message some "heavy weight," like my friend Dave, posts a message and I feel like a mouse in a lions den.)

"Resources" in my NT support experience means one of two things: RAM or disk space or both.

If you haven't done one or all of the following recently, try them and then try to do your Combo Box again.

1. delete all *.tmp files throughout your drive.2. Run scandisk and defrag. (Or, if you have WinNT and don't have Diskkeeper installed, run "chkdsk /f."3. Check you virtual memory settings. They may be too low.4. Finally, if none of the above resolves the issue, if you have less than 16 meg RAM and are running one of the later versions of Windows, consider installing more RAM.

(Now watch, someone will come along and blow me out of the water with some fantastic suggestion.)

Posted by Tim on May 02, 2001 5:58 AM

Kevin,

Thanks for your suggestions but I think it has something to do with the combo-box itself. I have a new laptop with loads of space and plenty of RAM, and I can usually run all sorts of stuff without getting into overload. Also, other users of this spreadsheet have got the same message when they use the box.

(8 responses) I have a column with either a value of 1 or blank. The sheet has a header. Is there code that can sort by value in column "Z", find the last

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View our Privacy Policy, Cookies Policy, and Terms of Use.