T
tracktraining
Hi All,
I have multiple combo boxes in my Userform. After the users have selected
their choices in each of the combo box, I would like all the information to
be group into one textbox (spacing by commas). At this stage the user is able
to change or add anything he/she wants. Then the user would hit the Submit
button and the data would be transfer to the active cell (the cell that the
user double clicked on to get into the userform). I am thinking of something
like this:
Private Sub Submit_button_Click()
Dim InvestStr As String
Dim transferstr As String
InvestStr = Me.combobox1.text, me.combobox2.Text, me.combobox3.text
Me.textbox1 = investstr
transferstr = Me.textbox1
Insert transferstr into the activecell
End Sub
Please help. thanks in advance!
I have multiple combo boxes in my Userform. After the users have selected
their choices in each of the combo box, I would like all the information to
be group into one textbox (spacing by commas). At this stage the user is able
to change or add anything he/she wants. Then the user would hit the Submit
button and the data would be transfer to the active cell (the cell that the
user double clicked on to get into the userform). I am thinking of something
like this:
Private Sub Submit_button_Click()
Dim InvestStr As String
Dim transferstr As String
InvestStr = Me.combobox1.text, me.combobox2.Text, me.combobox3.text
Me.textbox1 = investstr
transferstr = Me.textbox1
Insert transferstr into the activecell
End Sub
Please help. thanks in advance!