Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Arrays
Can control arrays be used in VB6? If so, can someone advise where I can see
some sample code where check boxes and option buttons are used? After doing some reading on the subject, it seems that if you create a control cox, for example, then copy and paste it to the same form you should be asked if you want to create an array. This does not happen for me and I cannot see and Index in the controls property list. Thanks in advance. Charles |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Arrays
They can be used in VB6. They cannot be used in VBA though - given the
newsgroup is this what you had in mind? Chris "Charles Watson" wrote in message ... Can control arrays be used in VB6? If so, can someone advise where I can see some sample code where check boxes and option buttons are used? After doing some reading on the subject, it seems that if you create a control cox, for example, then copy and paste it to the same form you should be asked if you want to create an array. This does not happen for me and I cannot see and Index in the controls property list. Thanks in advance. Charles |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Arrays
Charles,
They don't exist as such in VBA, but John Walkenbach has an example of using a class module to emulate it at http://j-walk.com/ss/excel/tips/tip44.htm -- HTH RP (remove nothere from the email address if mailing direct) "Charles Watson" wrote in message ... Can control arrays be used in VB6? If so, can someone advise where I can see some sample code where check boxes and option buttons are used? After doing some reading on the subject, it seems that if you create a control cox, for example, then copy and paste it to the same form you should be asked if you want to create an array. This does not happen for me and I cannot see and Index in the controls property list. Thanks in advance. Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Control arrays on Excel 2007 userforms | Excel Discussion (Misc queries) | |||
Control Arrays? | Excel Programming | |||
Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
On the lack of control arrays. | Excel Programming |