Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 and calendar control | Charts and Charting in Excel | |||
I need help with Excel 2007 and VB6 OLE Control | Charts and Charting in Excel | |||
Excel 2007 using control panel display settings | Excel Discussion (Misc queries) | |||
Excel 2007 vs. 2003 VBA Control Questions | Excel Discussion (Misc queries) | |||
Excel 2007: More control over graphs wanted | Excel Discussion (Misc queries) |