split function

[schuurke28]

how can i get the result of the split function in a variable?
i.e.:
Private Sub Form_Load()
Dim testje(10)
Dim mystring(10) As String
Dim i
i = 0
mystring(0) = "12,222,+,44,121"
For i = 0 To 4
testje(i) = Split(mystring(0), Chr(44))
Next i
End Sub

what am i doing wrong, testje(i) is not being filled..

[plenderj]

You have to declare a dynamic array for use with split :

Dim myStrArray() As String
myStrArray = Split(...)

[Cander]

Dim vntarray as variant
vntarray = Split(data,",")

[chrisjk]

Originally posted by Cander
Dim vntarray as variant
vntarray = Split(data,",")

Don't use variants!!