ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   New to VBA from VB6 (https://www.excelbanter.com/excel-programming/296019-new-vba-vb6.html)

SmilingPolitely

New to VBA from VB6
 
In VB I can have an array of controls. Can I also have this in VBA in
Excel?

I would like to have 15 similar buttons on my form, but I don't have the
originality to come with 15 unique btn.labels!

Any assistance is appreciated.


Howard Kaikow

New to VBA from VB6
 
VBA does not support control arrays.

--
http://www.standards.com/; See Howard Kaikow's web site.
"SmilingPolitely" wrote in message
. au...
In VB I can have an array of controls. Can I also have this in VBA in
Excel?

I would like to have 15 similar buttons on my form, but I don't have the
originality to come with 15 unique btn.labels!

Any assistance is appreciated.




SmilingPolitely

New to VBA from VB6
 
thanks howard....

I suppose btn1, btn2, btn3 it is then. Sigh.

Howard Kaikow wrote:
VBA does not support control arrays.




All times are GMT +1. The time now is 08:52 AM.

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