Nullware
Guru
I made this in a few minutes so it's not perfect but it works and I think it will be a good start for you. Hope it helps.
Example Usage:
Code:
'Where "Source" is your target string and "WordNumber" is the word you want to find
Private Function FindWord(Source As String, WordNumber As Integer) As Variant
Dim NewString() As String
'Strips one letter words from the source
For i = 2 To Len(Source)
If Mid(Source, i - 1, 1) = " " And Mid(Source, i + 1, 1) = " " Then
Source = Mid(Source, 1, i - 2) & " " & Mid(Source, i + 2, Len(Source))
End If
Next i
'Splits the modified source into words
NewString() = Split(Source, " ")
'Function returns the word you specified
FindWord = NewString(WordNumber - 1)
End Function
Example Usage:
Code:
Private Sub Command1_Click()
'Find the second word in the string from the textbox "Text1"
MsgBox (FindWord(Text1.Text, 2))
End Sub


