Combobox next i - values to be i & next i & - together

dizzydunham

New Member
Joined
Mar 22, 2014
Messages
30
Using " For I = 1 to Nb " and created Comboboxes on userform (Nb being the number inputted by the user to create the Comboboxes to input peoples names in e.g. 4 people need to have there names inputted into a sheet.)
I have happily got the code to input the values into columns.

What I am trying to achieve - The names are also added to a word document template as well, and the names need to be inputted in 1 string
eg, Rob Smith, Steve Smith, Joe Bloggs, etc, etc, etc.

So how do I write the code to read ; X = Combobox I & Combobox next I & Combobox the next I


Any help gratefully received

Thanks
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,911
Messages
6,175,324
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top