Array of Controls??

G

Guest

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!!!
 
G

GS

(e-mail address removed) 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!!!
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba array logic 3
Search an array of sheets for an array of numbers & return count of numbers 11
Array Formula 3
array within array 3
How to read Excel Array to vb.net Arrays? 20
Blue Screen of Death Using Dialog Boxes 5
Passing Control Names in an Array to another Procedure 4
Memory Issues with UserForms? 1

Top