Create an Object from string and variable

Hi everyone,

I have many textboxes on a Form named (tbx1, tbx2, tbx3, ect..). I am using a loop to cut down on code as I have 120 textboxes.

How do I create an object variable using the string "tbx" and i as the loop variable? (resulting in "tbx1" during the first run, "tbx2" during the second, ect..)

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

?

When I run it, I actually don't even make it to that part of the code... I get an error on line:

Formula:

Please Login or Register  to view this content.

How do I name the variable "tbx" & i ("tbx"string and "i" loop integer variable) so that VBA will recognize it as the name of my controls?

Thanks for the help

Should work if you have controls named tbx1 to tbx120

Please Login or Register  to view this content.