Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
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?
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 and calendar control Sheldon Charts and Charting in Excel 4 January 14th 08 07:54 PM
I need help with Excel 2007 and VB6 OLE Control Sri Charts and Charting in Excel 1 September 9th 07 04:50 AM
Excel 2007 using control panel display settings Mark Excel Discussion (Misc queries) 0 June 12th 07 08:36 PM
Excel 2007 vs. 2003 VBA Control Questions Ondy2112 Excel Discussion (Misc queries) 3 May 29th 07 10:41 PM
Excel 2007: More control over graphs wanted Thomas D Excel Discussion (Misc queries) 1 July 2nd 06 05:45 PM


All times are GMT +1. The time now is 08:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"