Object Array / Loop

In visual basic I could create and object arrary for the form objects and my code would look like this.

Please Login or Register  to view this content.

In VBA it looks like this.

Please Login or Register  to view this content.

Is there anyway to make the VBA code more like the Visual basic code? I have not been able to find any information on creating object arrays on the userform.

Tr with this code:

Please Login or Register  to view this content.

Regards,
Antonio

Userform1.Controls(i) already indexes all the controls. But it doesn't split them out by type.

What kind of control is Progress Bar1?

I'll assume that ProgressBar1 is a name that you gave to the control. This should create an array of the controls, ProgressBars.

Please Login or Register  to view this content.