Agreed To, but it might make the user experience less traumatic <g

Bob


"Tom Ogilvy" wrote in message
...
Multipage wouldn't reduce the number of controls. It would just put them
on
different pages - with 1500 controls, I would suspect multicontrol is
already in use <g.

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
I think a re-design is called for. You can access values on a form from
another form, prefix with the form name, or you could use the multi-page
control.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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....