Dynamic Textbox Naming Not Working

My goal: Loop through a table, increasing row by i. When matching value is found, put value of BCX & i into a textbox called dest1. If BCX and i is empty, then BCW and i is used.
My problem: I have textboxes dest1 to dest15. When dest1 is populated from the table, then I want the next match to use dest2, and so on.
I tried the code below that I found, but I keep getting an error that closes Excel. The code looks very straight forward so I'm not sure what I'm doing wrong. It worked just fine until I tried the dynamic textbox names.
Any help would be greatly appreciated. This is a critical process to making my whole userform practical. Thank you. -Luke

Please Login or Register  to view this content.

Untested by maybe this:

Please Login or Register  to view this content.

6StringJazzer: lRow is the last row in my table. tn is a number that Im matching in the table. The code runs on initialize. It was working fine until I added the j loop to dynamically change the textbox name that receives the value from the table.

Akuini: did not work.

My error says that it cannot find the specified object. The textboxes are within 2 frames. The first frame is "outerframe". Within outerframe I have 15 different frames, each of them have the 15 different textboxes that I want to update. I tried the below code, but same error. Do I need to reference both frames, or just the frame that the textbox is in? Thanks. -Luke

Please Login or Register  to view this content.

You don’t need to reference the frame, what I was trying to say with the code I suggested is that your loop structure is wrong.
Could you attach a sample workbook?

So, ummm, I figured out my own retardation but am too ashamed to admit what it was. Akuini, your code works just fine - thank you so much.

To be fair to those who have similar dumb issue, please name your controls what you aim to call them in your code.
SMH, sorry for wasting anyone's time....

You're welcome, glad to help, & thanks for the feedback.