View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default 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?
|