String Data Parser

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?

Dim Person() as String

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


puts the string into the array, as you said.

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

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

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

Private Type Person
Name as String
Age as Integer
End Type

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

VB Code:

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

Thank you :)