String Data Parser

[why]

i am trying to make a simple program which will take a string with information "Name, age; Name, age; " and so on and will move it into an array of a data structure called Person (containing Name, age) any idea of how a loop that does that would look like?

[BuggyProgrammer]

Dim Person() as String

Person = Split("George, 20; Frank, 99;Egads, 9999898",";")


puts the string into the array, as you said.

[why]

what i meant is that person is a data structure such as this:
Public Structure Person
Dim Name as String
Dim Age as integer

[why]

what i meant is that person is a data structure such as this:
Public Structure Person
Dim Name as String
Dim Age as integer
end structure

[BuggyProgrammer]

there's no such thing. do you mean UDT?

Private Type Person
Name as String
Age as Integer
End Type

[why]

well yeah ( itz just thats the way it iz on .Net)

[BuggyProgrammer]

Private Type Person
    Name As String
    Age As Integer
End Type
 
Option Explicit
Private Sub Form_Load()
Dim Persons() As Person
Dim Temp() As String
Dim Temp2() As String
Dim i As Long
Temp = Split("George,20; Frank,99;Egads,9999898", ";")
 
For i = LBound(Temp) To UBound(Temp)
    Temp2 = Split(Temp(i), ",")
    On Error Resume Next
    ReDim Preserve Persons(UBound(Persons) + 1)
    If Err Then ReDim Preserve Persons(0)
    
    Persons(UBound(Persons)).Name = Temp2(0)
    Persons(UBound(Persons)).Age = Temp2(1)
Next i
 
 
MsgBox Persons(1).Name
End Sub

[why]

Thank you