referencing combobox

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top