-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
memory limitations
-
how many textbox / combo boxes /command buttons etc can be added in a userform
After I designed a userform with about 125 textboxes, 20 command buttons, 20 checkboxes, 20 comboboxes .. I am gettign a message that " Not enough system resources to display completely" This message did not pop up before this. Tried to change the default printer but no effect. But did not...- dss28
- Thread
- display resources memory limitations userform vba & excel & forms
- Replies: 2
- Forum: Excel Questions
-
O
Mutliple Index match in one formula causes memory limit
Hi, I have a very long formula that gets the sales value from one of three sheets depending on some conditions. See below formula: =IFERROR(IF([@[12 months alive(Yes/No)]]="No",IFERROR(INDEX('BUDGET TY'!$Q$1:$Q$5000,MATCH([@[Store '#]],'BUDGET TY'!$B$1:$B$5000,0)),INDEX('BUDGET...- olofmur
- Thread
- index match long formula memory limitations
- Replies: 4
- Forum: Excel Questions
-
D
Is this going to work: 68.000 linked cells in a model?
Hi all, I have an excel model consisting of 68.000 cells with data. Basically it is an admin dashboard and central data collection (parent model). These cells are linked with 6 different excel models that are providing the data to the parent model and are in a cloud. The idea is that employees...- dms11
- Thread
- maximum size memory limitations
- Replies: 11
- Forum: Excel Questions
