Thanks Tom,
yes, its true i´m already using a multipage!
i´ve tried many things but nothing works,1.200 objects is the limit.one
person tell me that it could be a virtual memory problem...but i don´t think
so...the form really have that limit of objects....after read the suggestions
that all of you give to me,i created a second form with limits that the user
almost don´t recognize that is working on another form....the suggestion of
tab strip.......i don´t know how to programme on it,and the textboxes on my
case must have a descriiption before.....how could i insert so many textboxes
automatically....and its true to ,i really have to work with all of this
objects at the same time..

much thanks again
Miguel

"Tom Ogilvy" wrote:

Think you are going to have to use some creativity.

Maybe you can use a grid control or the OWC spreadsheet control to eliminate
a lot of your other controls.

Or maybe you just want to get your input from a spread sheet. I always have
a hard time thinking of any input screen that would required 1500 inputs.

Another approach would be to use a tab strip control with a userform with
let us say 300 controls on it. (5 tabs) that would give you virtually 1500
controls - you would just redefine the role played by the 300 controls based
on which tab is selected.

--
Regards,
Tom Ogilvy

"Liedson31" wrote in message
...
i must have on a form +/- 1.500 objects but excel craches,i only can put
1.200, it gives me an "out of memory error".

i´m using excel2000 and i´ve tried other versions but the error is the
same,when i want to put more objects excel, craches.i don´t want to have 2
forms,because the values on the form affect directly the other values and
both must be on the same form

thanks for any help....