Option Explicit
Private Sub Form_Load()
'==========================
Dim strFile As String
Dim varAllValues As String
Dim MyValues() As String
Dim i&
'provide full and valid path and file name
strFile = "c:\temp\test.txt"
Open strFile For Input As #1
'load entire file into a string variable
varAllValues = Input(LOF(1), #1)
Close #1
'in my test file delimeter is a carriage return, so
'I will split string based on it
MyValues() = SplitStringOnDelimiter(varAllValues, vbNewLine)
'you may now do anything you need to do with your data.
For i = 0 To UBound(MyValues) - 1 'this array is ZERO based
List1.AddItem MyValues(i)
Next i
End Sub
Public Function SplitStringOnDelimiter(varValues As Variant, _
varDelimiter As Variant) As Variant
SplitStringOnDelimiter = Split(varValues, varDelimiter, , vbTextCompare)
End Function