Variable Controls

[mojo249]

Hi

What's the syntax for referring to a variable control name?

I have a userform with 20 textboxes (txtAmount1, txtAmount2 etc) and I want to loop through each of those controls, so I want to do something like:

Please Login or Register  to view this content.

I know I can loop through all controls on the form (and restrict based on control name) but I want to be able to do something similar to the above for other reasons: I have another column of textboxes (txtSupplier1, txtSupplier2 etc) and if I update txtSupplier2 then I want to update the corresponding txtAmount2.

Any help is appreciated.

Dion

[mrice]

Something like..

Please Login or Register  to view this content.

[barryleajo]

Try

Please Login or Register  to view this content.

[mojo249]

Perfect. Both worked.

Thanks very much.