View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Informative Informative is offline
external usenet poster
 
Posts: 1
Default 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?