I need to make a few userforms each of which will have a large number of
check boxes. It would be great if I could have an array of checkboxes so
that I do not have to write separate code for wach one. Is that possible?

Thanks!!!

used his keyboard to write :
I need to make a few userforms each of which will have a large number of
check boxes. It would be great if I could have an array of checkboxes so
that I do not have to write separate code for wach one. Is that possible?

Thanks!!!

No! VBA does not support control arrays. The best you can do is have
them all call the same procedure and pass their 'Tag' property
containing 'your' index ref to each control.

Also, if you're using several userforms to handle too many controls to
fit on a single userform, use Frames or a MultiPage so it works like a
wizard that users can progressively navigate through.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion