those limits are a given.
you've got to live with it.

but redesign to bring the number of objects down

iso separate optionbuttons and checkboxes use
(multiselect) listboxes

or use listviews or treeviews to organize your data

or those values that should not be changes by users:
dont put them in objects but in array variables

be creative.. but dont bother the user (and excel)
with 1500 objects.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Liedson31 wrote :

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