Hi,
When i selected a dropdown value in combobox in Macro-enabled Excel, it shows an error most of the times showing "Not Enough memory to display".
There are not many values in the Combobox still it shows the error.
This error keep on occuring again and again hence the necessary code in the combobox doesn't run. As a result do not get the excepted result.
Could anyone please help me as it very urgent for me to solve this problem?
Make sure the references to the comboboxes are fully qualified.
Userform1.ComboBox1...
Sheet1.ComboBox1....
David
(*) Reputation points appreciated.
Thank you very much for the reply David.
I gave fully qualified name to all the combos present in the workbook but it doesn't work.
The exact error it shows is"Not enough system resourses to display completely" . It doesn't occur all the time but it occurs sometime.
I don't know what to do.
Kindly please help.
Thank you in advance.
How much code do you have? How large is the workbook?
It would help us determine the problem if you would at the minimum post the code (or even upload the workbook).
It contains four sheets and the code is not much and neither much controls on it. .
The workbook is developed in Excel 2003.
two sheet has 3 combos each.
One sheet has 110 combos.
It doesn't show this error on the sheet which has 110 combos but it shows on one containing 3 combos.
---------- Post added at 11:52 AM ---------- Previous post was at 11:51 AM ----------
The size of the workbook is 1 MB.
---------- Post added at 11:54 AM ---------- Previous post was at 11:52 AM ----------
the code in the combobox is as follow. But it doesn't occur for this combobox only.
Please Login or Register to view this content.
Last edited by Cutter; 08-10-2012 at 07:48 PM. Reason: Added code tags
It's very difficult to troubleshoot intermittent errors.
Try hard coding the range to the combobox values.
If you use rowsource, switch to Range"A1:A" & lastrow) and loop through the range, adding the items to the combobox.
In other words, try changing dynamic values with static ones to try and isolate the problem.
Try creating a new workbook, adding items back one at a time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks