Control arrays on Excel 2007 userforms

  • Thread starter Thread starter Informative
  • Start date Start date
I

Informative

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?
 
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
| 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?
|
 
Back
Top