Naming labels on Input Form problem

I have an input form with a column of labels that I wish to select in sequence and fill their captions from corrisponding cells on a spreadsheet. The labels are named lblOAK1, lblOAK2, lblOAK3 etc. I have tried to select the correct label with the following code but I can't get it to work:

Please Login or Register  to view this content.

What am I doing wrong here?

Paul

Hello PaulC,

To access an object on a UserForm, you use the object's name as the index in the Controls collection object of the UserForm. See the code in blue below...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Many thanks Leith - using

Please Login or Register  to view this content.

worked perfectly - I obviously need to learn about the Controls collection

Thanks again,

Paul