Name each label after each cell using loop

[unreal_event_horizon]

Hi All,
back again to pick your brains, need help.

what i have is a userform with 42 (yes 42) labels. (actually 84)

I want to name each of these labels after 42 cells in the excel file, i have another 42 labels on the sheet that i want to have equal values for each label name.

here is what i attempted

Please Login or Register  to view this content.

feel free to point out my issue but its the line with

Please Login or Register  to view this content.

which is failing

any help is appreciated.

i was using the

Please Login or Register  to view this content.

but it began naming the last 42 labels after blank values......

anyway again all help appreciated.

many thanks
Dave

[Kaper]

How about:

Please Login or Register  to view this content.

[unreal_event_horizon]

Hi Kaper, many thanks, reputation added.

can i try that for other controls?

ie.

Please Login or Register  to view this content.

[Kaper]

Thanks for reputation.

Yes, you can.
with textbox you can use either value or text property.