Code:
Dim strArray() As String
Dim intIndex As Integer
Dim intCount As Integer
Dim intWords As Integer
' Split the text into words.
For intIndex = 1 To Len(Text1)
If Mid$(Text1, intIndex, 1) <> " " Then
ReDim Preserve strArray(intWords)
Do Until Mid$(Text1, intIndex, 1) = " " Or intIndex > Len(Text1)
strArray(intWords) = strArray(intWords) & Mid$(Text1, intIndex, 1)
intIndex = intIndex + 1
Loop
intWords = intWords + 1
End If
Next
' Find those longer than 8
For intIndex = 0 To UBound(strArray)
If Len(strArray(intIndex)) > 8 Then
intCount = intCount + 1
End If
Next
MsgBox "txtmain contains " & intWords & " words " _
& "of which " & intCount & " are longer than 8 characters"
End Sub