loop through concatenated object names and variables

**TYork** · 06-24-2010, 02:26 PM

So I have the following code which works:

Please Login or Register  to view this content.

I'd like to simplify this but can't seem to figure out how. So far I have the following code which DOES NOT work.

Please Login or Register  to view this content.

Any help would be appreciated, thanks.

**6StringJazzer** · 06-24-2010, 02:51 PM

I think something like this should work but to test it out I would need to know where are your text boxes--in a worksheet, or on a form? And are you using ActiveX or Form controls?

Please Login or Register  to view this content.

**TYork** · 06-24-2010, 03:02 PM

The textboxes are on a userform and I am using activex controls.

**TYork** · 06-24-2010, 04:29 PM

Your original code works, although "Range()" need to be removed from around "Calculations!AG" & i + 1

Thanks for your help

**6StringJazzer** · 06-24-2010, 07:42 PM

Originally Posted by TYork

Your original code works, although "Range()" need to be removed from around "Calculations!AG" & i + 1

Thanks for your help

Sorry for the glitch. I did a generic test and not one exactly like your situation. I edited my code afterwards to put that in. Glad you were able to work around it.