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

    
For i = 2 To lRow 'number of rows in table
        For j = 1 To 15 'number of textboxes in the userform
            If Range("BCO" & i) = tn Then 'tn is the static number that is matched in the table
                If Range("BCX" & i) = "" Then
                    Me.Controls("dest" & j).Value = Range("BCW" & i).Value
                Else
                    Me.Controls("dest" & j).Value = Range("BCX" & i).Value
                End If
            End If
        Next j
    Next i