aworthey
07-29-2016, 07:31 AM
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:
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 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:
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