***TL-DR; i need a way to call a variable name. So instead of calling TB\_Name1\_R1 i can call TB\_Name1\_R[i] (or whatever its called in VBA)***

I am right now working with multiple userforms in excel with VBA. 

The setup is as such: I have a main window with a lot of textboxes for input of data by the user. They are all in rows called `TB_Name1_R1`, `TB_Name2_R1` .. next row is `TB_Name1_R2`, `TB_Name2_R2`.. and so forth. 

A second userform for swapping holds 2 dropdown boxes with lists of the rows, so you can choose lets just say row 1 and 2, and then the idea is that you can swap the data in the two rows. So the userform calls 

```
Private Sub CB1_Click()

Dim Ra As Integer
Dim Rb As Integer

Ra = RowA.ListIndex
Rb = RowB.ListIndex

If Ra = -1 Or Ra = 10 Or Ra = 15 Or Rb = -1 Or Rb = 10 Or Rb = 15 Then
    MsgBox "Wrong input, please redo", , "Wrong Input"
Else
    Call Module1.Move(Ra, Rb)

    Me.Hide
End If

End Sub

```

All of that works fine.

NOW my problem is as follow. How do i smartest create some code where the called sub use the information sendt to swap the data between the rows chosen?

The only thing i can come up with (and yes it is so very basic) is a hole lot of 

```
if a = 1 then
holder1 = TB_Name1_R1
holder2 = TB_Name2_R1

if a = 2 then
holder1 = TB_Name1_R2
holder2 = TB_Name2_R2

```

And that simply cannot be the answer