I have created a user dialog form with three tabs. Each of
the tabs list on of 20 different companies for which a
user can print a financial statement (P&L, Bal Sht, CF).
Therefore, by design, I have 60 different checkboxes. Each
check box is named in accordance with the company name and
the statement type (IE: plComp1cb, bsComp1cb...).

To print the selection of reports, I am using arrays for
each of the variables. Rather than list each of the 60
checkboxes I though I might be able to concatenate the
name, then attain the value for that check box. therefore,
I have two arrays that would merge to create a checkbox
name:

Array1(pl, bs, cf)
Array2(Comp1, Comp2, Comp3...)

In short, if I were to use loops and if statements to
check the value (true / false), I should be able to attain
the value of each check box, ascertain the value and print
(or skip printing). I have not been able to determine the
correct syntax to check the checkbox. I have done similar
techniques using worksheets - sheet(array1 & array2).value
but have been unsuccessful in using the same technique for
checkboxers - checkbox(array1 & array2).value

Any suggestions?

Allan