OLE Object Array Declaration Syntax Problem

**beat** · 04-26-2013, 07:07 AM

I have 6 toggle buttons

Toggle1
Toggle2
Toggle3
etc

I am wondering if its possible to have them as an array?

Please Login or Register  to view this content.

Thanks for an insight

Beat

**Kyle123** · 04-26-2013, 07:40 AM

Possibly:

Please Login or Register  to view this content.

**Colin Legg** · 04-26-2013, 08:02 AM

Sure, you can if you want to. If we keep the code the same as you presented it, it would be:

Please Login or Register  to view this content.

There are various other options available to you too. For example, you could use the Userform's controls collection:

Please Login or Register  to view this content.

**beat** · 04-26-2013, 08:08 AM

Superb thanks,

ill give it a try

**snb** · 04-26-2013, 08:11 AM

in a userform:

Please Login or Register  to view this content.

Re: OLE Object Array Declaration Syntax Problem