Need to continue long list of variables on the next line

[rja]

I have a line in my VBA code with a long list of variables. My list has hit the end of the line and I am not sure how to continue on the next line. I have tried using the line break character ( _) but that does not work. Here is a sample of the line. The actual line of code has many more variables.

ColorFP = "(""0MA114"", ""0MA115"", ""00A050"")"

Any Ideas?

Thanks

[orange]

If it is a string, then you can do as in this example where the long string of text is continued on 2 additional lines

 Dim SQLInterim as string
 SQLInterim = "INSERT INTO VaUser ( EmplId, [Employee Name],  [Payment Amount],[Payment Date]," _
                 & "[Payment Number] )" _
                 & " SELECT VATrans.EmplId, VATrans.[Employee Name], VATrans.AmountofPaymentsInBetween,"

Here is another - spread across several lines

  Dim sqla As String
      sqla = "CREATE table tblxmlnodes" & _
       "(id counter,  nodeparent Number " & _
            "  , nodename varchar(50)" & _
            "  , nodechain varchar(250)" & _
            "  , nodelevel varchar(20)" & _
            "  , nodeorder NUMBER " & _
            "  , nodeleaf varchar(30)" & _
            " , nodeValue varchar(250));"

For your data, I would probably put them into a table.

Another option is to put the values in an array.
Dim colorFPArr(2) as string
ColorFP(0) ="0MA114"
ColorFP(1) ="0MA115"
ColorFP(2) ="00A050"

If you have a long list of text values, you could put them into a table.
Depends on what you're trying to accomplish.