Multiple line list of values for a combobox

[ll4u76]

I have a long list of values to add to my combobox. I had to break the list down into a couple of lines. I have typed the code a couple of different ways but keep getting Complie errors. Here are some examples:

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", "|")


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", "|")

Please assist in typing this code to read all of the data items for the combobox without getting an error.

[Tinbendr]

What error are you getting?

Start with a small list, then add to it.

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

If that runs OK, then add
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|", "|" )


I copied your code and it works on my machine.