combining multiple userform textbox values into one cell
<p>I have a userform that is filled out and enters the data on a spreadsheet.
One feature I've added is frame of 10 textboxes which remain hidden unless data is entered in the previous box, allowing up to 10 entries.
Because the user is entering participants' names in these text boxes, I want them all to fill the same cell of the spreadsheet, separated by commas.
At first I entered the code without thinking and would receive 9 commas in the cell even when no names were added.
I've since managed to get the second text box value preceded by a comma added to the cell but cannot get the value of any additional textboxes (3-10) to do the same.</p>

<pre><code>ws.Range("I" &amp; LastRow).Value = tbPart1.Value
If Not IsEmpty(tbPart2.Value) Then
ws.Range("I" &amp; LastRow).Value = tbPart1.Value &amp; "," &amp; tbPart2.Value
ElseIf Not IsEmpty(tbPart3.Value) Then
ws.Range("I" &amp; LastRow).Value = tbPart1.Value &amp; "," &amp; tbPart2.Value &amp; "," &amp; tbPart3.Value

End If
</code></pre>