ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control Arrays (https://www.excelbanter.com/excel-programming/316739-control-arrays.html)

Charles Watson

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



Chris Rae

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




Bob Phillips[_6_]

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






All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com