Appropriate Display of a string in combobox unable to put "," at correct placement with Split

[SamDsouza]

Hi I've been banging my head just for simple formating using Split

Can some help me to correct

dim myArrayList as Variant, txtString As String
dim RowNo as Long
dim ColNo as Long

txtString = txtString & RowNo & ","  & ColNo & " "
myArrayList = Split(txtString,", ")
Combobox1.List = myArrayList

what i am getting in combobox1
1,1 1,2 1,3 2,1 2,2 2,3 3,1 3,2 3,3 4,1 4,2 4,3 5,1 5,2 5,3 6,1 6,2 6,3 7,1 7,2 7,3

What is correct format by using Split function to get desired below correct formatting for Combobox
So that values in comboBox to get following i.e RowNo Comma/Delimeter Space and ColNo below is the structure
1, 1
1, 2
1, 3
2, 1
2, 2
and so on...
SamD
188

 

[RoryA]

You are splitting on a sequence that is not present in the string. You could do something like this:

txtString = txtString & RowNo & ", "  & ColNo & "^"
myArrayList = Split(txtString,"^")

 

[SamDsouza]

RoryA

You are splitting on a sequence that is not present in the string. You could do something like this:

Ok, Realised

txtString = txtString & RowNo & ", "  & ColNo & "^"
myArrayList = Split(txtString,"^")

Thank you ! Works Perfectly
SamD
189