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

Tim Grollman · Mar 15th, 2002, 05:54 AM

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 · Mar 15th, 2002, 06:24 AM

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 · Mar 15th, 2002, 07:32 AM

Hi Tim

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

Mar 15th, 2002, 06:24 AM	#2
MrExcel . Join Date: Feb 2002 Location: Akron, Ohio USA Posts: 789	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. __________________ Preview my latest book for Free

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 05:54 AM	#1
Tim Grollman Board Regular Join Date: Feb 2002 Posts: 129	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.

Mar 15th, 2002, 07:32 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Tim In addittion you my have a problem with the code that is behind the ComBobox, what does it do?