referencing combobox
 

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!
--
Learning

referencing combobox
 

Try the & symbol
activecell=combobox1 & "," & combobox2 & "," & combobox3


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=66627

referencing combobox
 

thanks! i finally figured it out.
--
Learning


"Stringer" wrote:


Try the & symbol
activecell=combobox1 & "," & combobox2 & "," & combobox3


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=66627