Function to find the first Word in a string:   Return to List

Private Function FindFirstWord(ByVal MyString as String)
WordFoundFlag = 0
For i = 1 To Len(MyString)
    Char = Mid(MyString, i, 1)
    If Char Like "[A-Za-z-]" And WordFoundFlag = 0 Then
        WordFoundFlag = 1
        StartPos = i
    ElseIf Char Like "[!A-Za-z-]"And WordFoundFlag = 1 Then
        GoTo BYE
    End If
Next
BYE:
FindFirstWord = Mid(MyString, StartPos, i - StartPos)
End Function



Note to Webmaster