[Excel]List Box VBA PROBLEM

[allankevin]

Hi Guys,

How can i show the item from a textbox to the listbox? I want to get to item in txtdesc, txtdate,txttotal,txtapp to show in my listbox..

can someone help me on this? THanks!!

here's my code

Private Sub UserForm_Initialize()
Dim MyList(10, 3) As String
Dim i As Long
MyList(0, 0) = "Description"
MyList(0, 1) = "Date"
MyList(0, 2) = "Total Claim"
MyList(0, 3) = "Approved"
For i = 1 To 10
?
?
?
ListBox1.ColumnCount = 4
ListBox1.List = MyList
End Sub