I have a userform with checkboxes. As each checkbox is selected, a
secondary form shows, which has checkboxes and option buttons. After
gathering input from these controls, various things are done.

I wonder what is the best way to "capture" the values from the various sub
forms, checkboxes, and optionbox groups.

I have considered using an array(x=1 to 8,y=1 to 5,z=1 to 5), where x would
represent the subforms, y the checkboxes, and z the option buttons, but need
direction. I thought using a public array variable would make the values
easily "retrievable" through all modules.I thought about assigning a value
to one cell of the three-dimenstional array a value when the control was
true, but don't know how to refer to the controls by name.

I also have considered just looping through the various forms on the
controls, but is there a efficient way to loop through all the checkboxes
and option buttons for the various subforms? With hopes of easy looping, I
have prefaced the names of all the sub userforms with "ufm1Blah...ufm8Bleh",
the checkboxes with "ckb1Name...ckb5Name", and the option buttons with
"opt1One...opt5Five".

Can anyone give me a kick? I think I should be looping through all the
controls of the project (and then consider the forms that have left(asdf,4)=
ufm or ckb or opt, but I'm stuck.

TIA