Reference Control by Name

[barryleajo]

Hi Everyone

I want to populate a number of text box controls on a userform using a For Next loop.

For example to populate text box controls: txtMyVal1, txtMyVal2, txtMyVal3 using a loop which concatenates the string"txtMyVal" with the loop counter value.

It is similar to the INDIRECT() function in Excel.

Whilst I can build the string OK I don't know how to use this as the control's name.

Is this possible?

WIth thanks
barry

[Richard Buttrey]

Hi

Within the For..Next loop with x as the loop counter

Please Login or Register  to view this content.

HTH

[barryleajo]

Hi Richard
Very many thanks for your quick reply.
Works a treat.
It would have taken me ages to have uncovered this.
Thanks for passing on your knowledge.
I'll mark this as solved and tip your scales!
barry

[Richard Buttrey]

Thanks Barry,

Glad to have been able to help. That's why we're here.

Rgds