how do i run a loop through 20 textboxes?

[kevinu]

Currently I have code that changes values of 10 textboxs and I'd like to run through them as a loop instead of 10 lines of code. I plan on making it 20 textboxes and having 4 other conditions so i want to cut down on the length of code if possible. I cant seem to get it to accept my loop.

Here is what I have that works in the long code

Please Login or Register  to view this content.

I've tried this but it wont accept it

Please Login or Register  to view this content.

I tried (textbox & i) and ("textbox" & i) but non work. I cant figure out the syntax

[Winon]

Hi kevinu,

Please could you attach a sample workbook, since it contains a Userform (not a picture or pasted copy).
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[mikerickson]

Try

Please Login or Register  to view this content.

[kevinu]

That did the trick Mike. I didnt use .controls. thanks