It's only a little combo box....

[Tim Grollman]

Does anybody know why I keep getting the "Not enough resources to display completely" riposte when I try to change the selection in a combo box? I don't think it's memory-related because other users are getting it as well and it happens when nothing else is open, but not all the time. Is the combo box corrupted? I've cut it and put in a new one, but the same thing happens.

 

[MrExcel]

Do you have a lot of VBA code in the sheet?

Try this:
Go to the VBA editor.
Close (using the X in the upper right corner) every module and userform.
Save and Close the File
Close Excel

Re-open the file.

I've experienced situations where closing all of VB components would stop the memory issues. My theory is that even if you don't open the VB Editor, Excel must open those in the background if you last left them open.

 

[Dave Hawley]

Hi Tim

In addittion you my have a problem with the code that is behind the ComBobox, what does it do?