<div>
If you have the comboboxes done, to fill the textbox you would just use the Join function in the afterUpdate for all the comboboxes... 
 

<pre><code id="code-20-39205039-1">dim arr(4)
arr(0) = combobox1.value
arr(1) = combobox2.value
arr(2) = combobox3.value
arr(3) = combobox4.value
arr(4) = combobox5.value

Textbox.value = Join(arr, &quot;;&quot;)</code></pre>
</div>

If you have the comboboxes done, to fill the textbox you would just use the Join function in the afterUpdate for all the comboboxes...



dim arr(4)
arr(0) = combobox1.value
arr(1) = combobox2.value
arr(2) = combobox3.value
arr(3) = combobox4.value
arr(4) = combobox5.value

Textbox.value = Join(arr, ";")

<div>
<div class="content wysiwyg-content">
Excel 2010 vba 
 
Userform 
Multipage Tab Specifically &quot;page 9&quot; 
 
Textbox1 
8 comboboxes 
 
Combobox1 to Combobox8 
Scenario: 
 
Comboxes are filled with items. 
 
Not All comboboxes are filled 
Combobox1 to combobox 5 may only contain items at times.. 
 
&nbsp; 
What I need: 
 
As i make selections in the comboboxes. 
I need the Textbox to be updated with the choices from the comboboxes. 
With a seperation character semicolon &nbsp; &nbsp;; 
 
Combobox1 selected = drill 
Combobox3 selected = 1/2 inch 
combobox6 selected = brown 
 
The the result in the Textbox could be: 
drill;1/2 inch;brown 
 
 
Thanks 
fordraiders
</div>
</div>

Excel 2010 vba

Userform
Multipage Tab Specifically "page 9"

Textbox1
8 comboboxes

Combobox1 to Combobox8
Scenario:

Comboxes are filled with items.

Not All comboboxes are filled
Combobox1 to combobox 5 may only contain items at times..

 
What I need:

As i make selections in the comboboxes.
I need the Textbox to be updated with the choices from the comboboxes.
With a seperation character semicolon    ;

Combobox1 selected = drill 
Combobox3 selected = 1/2 inch
combobox6 selected = brown

The the result in the Textbox could be:
drill;1/2 inch;brown


Thanks
fordraiders

Textbox with combobox selection choices

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.