Excel 2013>VBA>UserForm>TextBox>Name as variable

Hello,

I'm trying to call the name of a textbox on my userform from a variable. Is that possible?

I know that my variable is working correctly. And I know that the value I want to place in the textbox is working correctly. I just can't get the textbox name from the variable.

Here's the code:

Code:

---

Private Sub CommandButton5_Click()
 
 Dim boxSMARTdest As String
 Dim dest As MSForms.TextBox
 
 boxSMARTdest = frmSMARTNumberPicker.bxSMRTvalue.Caption
 dest = Forms("frmFinishTA").Controls(boxSMARTdest)
 
 With dest
  .Text = frmSMARTNumberPicker.Label1.Caption
 End With
 
 Unload Me
 
End Sub

---

I'm pretty sure that the Forms("frmFinishTA") is a syntax error.
I'm very sure that you need to use the keyword Set when assigning the Textbox variable, dest.

mikerickson,

Thanks for responding.

How would I use the keyword Set when assigning the Textbox variable, dest? I'm not familiar with that.

I reread your post after I had more time...I understand what you're saying now! Ha.

Here's what I got to work:

Code:

---

Private Sub CommandButton5_Click()
   
    Dim boxSMARTdest As String
    Dim dest As MSForms.TextBox
   
    boxSMARTdest = frmSMARTNumberPicker.bxSMRTvalue.Caption
    Set dest = frmFinishTA.Controls(boxSMARTdest)
   
    With dest
        .Text = frmSMARTNumberPicker.Label1.Caption
    End With
   
    Unload Me
   
End Sub

---

Now you've developed it, shorten it (untested):

Code:

---

Private Sub CommandButton5_Click()
frmFinishTA.Controls(frmSMARTNumberPicker.bxSMRTvalue.Caption).Text = frmSMARTNumberPicker.Label1.Caption
Unload Me
End Sub

---