Office & productivity software forum: How do you add a long list of values to a combobox?

Should I write the code as:

Me.ComboBox1.List = Split("item 1 | item 2 |" & _
"item 4 | item 5 |......" & _
"item 6 | item 7 | item 8", "|")

http://msdn.microsoft.com/en-us/library/6x627e5f%28v=vs.80%29.aspx tells the syntax.

Your code above, when combined to one line, reads:
Me.ComboBox1.List = Split("item 1 | item 2 |" & "item 4 | item 5 |......" & "item 6 | item 7 | item 8", "|")
which after executing the string concatenation becomes

Me.ComboBox1.List = Split("item 1 | item 2 |item 4 | item 5 |......item 6 | item 7 | item 8", "|")

That's nearly good. But you would like add a space before 'item 1' and 'item 4' or remove the spaces between the other items, and remove the ....... also, I think.

Kees

This my actual data string:

Me.ComboBox1.List=Split("item 1|item 2|item 3|item 4|item 5|item 6|item 7|item 8|item 9|item 10|item 11|item 12"
"item 13|item 14|item 15|item 16|item 17|item 18|item 19|item 20|item 21|item 22|item 23|item 24|item 25|item 26"
"item 27|item 28|item 29|item 30", "|")

I had to split the data items into multiple lines. I am not sure if the " at the end of line 1 and 2 and at the beginning of line 2 and 3 is correct.

All that needs to be added is & _ at the end of the first and second line.
The & is the string concatenation, the _ serves to indicate that the statement is continued at the next line.

Kees

Me.ComboBox1.List=Split("item 1|item 2|item 3|item 4|item 5|item 6|item 7|item 8|item 9|item 10|" & _
"item 11|item 12item 13|item 14|item 15|item 16|item 17|item 18|item 19|item 20|item 21|item 22|item 23|" & _
"item 24|item 25|item 26|item 27|item 28|item 29|item 30", "|")

I added the & _ and got a "Compile error: Expected: list separator or )" error.

I copied copied your code to a VBA-window in Word 2010, resulting in
Private Sub UserForm_Click()
Me.ComboBox1.List = Split("item 1|item 2|item 3|item 4|item 5|item 6|item 7|item 8|item 9|item 10|" & _
"item 11|item 12item 13|item 14|item 15|item 16|item 17|item 18|item 19|item 20|item 21|item 22|item 23|" & _
"item 24|item 25|item 26|item 27|item 28|item 29|item 30", "|")
End Sub
which compiled without any errors.

I don't see why it shouldn't with you.

Try a simple variant:
Me.ComboBox1.List = Split("item 1|item 2", "|")
Works with me.

Moreover, there's no need to split the text across several lines. A line in VBA can be VERY long, using the horizontal scrollbar.