I was wondering what the button click form would look like for this..thanks so much!!

Write a function called RestofString that accepts two parameters. The first is the String to be processed. The second, is a String to search for within the first String. If the String is found, return a String containing the remainder of the String after the first occurrence of the search String. If the String is not found return an empty String. Therefore, if RestofString is called with "Hello, I must be going" and "I", the function will return " must be going".
Private Function RestOfString(ByVal strWholeString As String, _
ByVal strSubString As String) As String
Dim intLocation As Short

intLocation = InStr(strWholeString, strSubString)

Return (Mid(strWholeString, intLocation + Len(strSubString)))
End Function

__________________
Yahoo! Answers 4ever