Issue with For...next loop

[Charles1104]

Hi,

I am having a small issue in a code. I have the following loop:

Please Login or Register  to view this content.

I have three labels (Label1, Label2 and Label3).

My issue is in joining Label with the I of the loop !

Thank you for your help,

Charles

[RHCPgergo]

Hi,

I'm not sure if you can do that, but here's a workaround.

Please Login or Register  to view this content.

[Charles1104]

Thank you for your fast answer. I wanted to make the code shorter using the "for... next" loop but it's fine like this.

Bye,

Charles

[mike7952]

Anther way

Please Login or Register  to view this content.

[Norie]

Charles

You can do it without a loop but the syntax would be slightly different.

Where are the labels located? Woksheet? Userform?

[RHCPgergo]

Well, it has the same amount of rows now... :P
(Of course that wouldn't be the case if you had four or more labels.)

[Norie]

Here's an example for labels on a userform.

Please Login or Register  to view this content.