CheckBox values
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 |
All times are GMT +1. The time now is 09:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com