What version of VB do you have???
If you have VB 6 then use Split Function.
example:
Code:
Option Explicit
Private Sub Form_Load()
Dim strTest As String: strTest = "Hello, how are you doing?"
Dim strArray() As String
Dim I As Integer
strArray() = Split(strTest, " ", , vbTextCompare)
For I = 0 To UBound(strArray)
If Right(strArray(I), 1) = "," Then '//check for unwanted symbols like ,.:;)( etc
strArray(I) = Left(strArray(I), Len(strArray(I)) - 1)
End If
Next I
For I = 0 To UBound(strArray)
Debug.Print I + 1 & " - " & strArray(I)
Next I
End Sub
'It would print:
'1 - Hello
'2 - how
'3 - are
'4 - you
'5 - doing?
Hope this makes some sense
Post #505
[Edited by QWERTY on 08-07-2000 at 12:14 PM]