Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox value to be set as Target for referencing from. How ? | Excel Programming | |||
Referencing Combobox with other cells in a different worksheet?? | Excel Programming | |||
referencing ComboBox | Excel Programming | |||
referencing ComboBox | Excel Programming | |||
Referencing a ComboBox control from a Workbook Object? | Excel Programming |