VB Code:
Dim DataToRead(1) As String
Private Sub Form_Load()
DataToRead(0) = "1000,20000,3000,40000,50000,"
DataToRead(1) = "60000,7000,80000,9000,1000,"
ParseFile
End Sub
Public Sub ParseFile()
Dim SingleLine As String
Dim StartPos As Integer
Dim EndPos As Integer
Dim ParsedString As String
For x = 0 To UBound(DataToRead)
StartPos = 1 'initialize the starting position
SingleLine = StringArray(x)
Do While StartPos <= Len(SingleLine)
'find the delimiter position
EndPos = InStr(StartPos, SingleLine, ",")
'if delimiter is not at end of string, move end position past string length
If EndPos = 0 Then EndPos = Len(SingleLine) + 1
'get the value string
ParsedString = Mid(SingleLine, StartPos, EndPos - StartPos)
Combo1.AddItem ParsedString '<== add the items to your combobox here
'set the next starting position 1 past the current delimiter
StartPos = EndPos + 1
Loop
Next
End Sub