Control arrays on Excel 2007 userforms
Up through Excel 2003 it has not been possible to add a control array similar
to what was possible in VB6 and up. Having to custom code for ten uniquely named checkboxes checkbox1 checkbox2 through checkbox10 could be hundreds of lines of code. It is obvious why this would be useful. Presenting a form with a set of say ten checkboxes or radio buttons as an array requires a mere half dozen lines of code using the array element in a loop. Does Excel 2007 finally include thie feature? |
Control arrays on Excel 2007 userforms
Does Excel 2007 finally include thie feature?
No. If you haven't seen this workaround: http://www.j-walk.com/ss/excel/tips/tip44.htm -- Jim "Informative" wrote in message ... | Up through Excel 2003 it has not been possible to add a control array similar | to what was possible in VB6 and up. | | Having to custom code for ten uniquely named checkboxes checkbox1 checkbox2 | through checkbox10 could be hundreds of lines of code. | | It is obvious why this would be useful. Presenting a form with a set of say | ten checkboxes or radio buttons as an array requires a mere half dozen lines | of code using the array element in a loop. | | Does Excel 2007 finally include thie feature? | |
All times are GMT +1. The time now is 12:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com