Out of memory using Multipage

[johnw]

Word 2000
I'm a beginner but enjoying learning.
I have designed a document with about 80 Dropdowns in it.
Each Dropdown has the same five choices available (eg: a blank, A, B,
C, D).

It all works fine but my wife has to move around the document filling
each one in. It needs to be in a brochure style, so she has to move
from column to column and over two pages - a bit of a nuisance.

I'd like to present her with a UserForm Multipage with these same
Dropdowns on to input the answers which would then be inserted into
the document. It would take about a dozen pages on the Multipage.

I've designed this after hours of work but when I try to run it - it
gives me an out of memory error and won't bring up the Userform.

My question:
Is this too many Dropdowns for Word's memory or am I doing something
wrong?

80 Dropdowns work fine in the document but not in a Userform.

Thank you for any replies.
John Walker

 

[Jonathan West]

Hi John

Word 2000
I'm a beginner but enjoying learning.
I have designed a document with about 80 Dropdowns in it.
Each Dropdown has the same five choices available (eg: a blank, A, B,
C, D).

It all works fine but my wife has to move around the document filling
each one in. It needs to be in a brochure style, so she has to move
from column to column and over two pages - a bit of a nuisance.

I'd like to present her with a UserForm Multipage with these same
Dropdowns on to input the answers which would then be inserted into
the document. It would take about a dozen pages on the Multipage.

I've designed this after hours of work but when I try to run it - it
gives me an out of memory error and won't bring up the Userform.

My question:
Is this too many Dropdowns for Word's memory or am I doing something
wrong?

80 Dropdowns work fine in the document but not in a Userform.

Thank you for any replies.

There's a hard limit of about 400 controls of all kinds on a Userform - that
includes everything, dropdowns, textboxes, frames, pages, labels etc. If you
think you are hitting that limit, then you may need to redesign your form.

Otherwise, if you have spent a lot of time tweaking your userform and have
saved and resaved the template many times, you may be suffering from a touch
of template bloat, which causes all kinds of unpredictable errors and
crashes. Take a look at the following article for more information and a
means of fixing it.

Combatting Template Bloat
http://www.mvps.org/word/FAQs/MacrosVBA/TemplateBloat.htm

 

[johnw]

On Tue, 20 Jan 2004 23:09:07 -0000, "Jonathan West" <[email protected]>
wrote:

Thank you for your reply Jonathan.
I am no where near 400, maybe a hundred or so - so I'll try the other
option.
Many thanks
John