num-of-substrings

Count The number of Substrings Within A String

Count The Number of Substrings Within A String

This sample code will tell you that the string 'is' appear 2 times in the
string 'this is my string'.
This code use the function 'split' that available only in Visual Basic
6.0 and above.

Form Code

Private Sub Form_Load()
myString = "this is my string"
tempString = Split(myString, "is")
MsgBox "'is' appears in '" & myString & "' " & UBound(tempString) & "
times."
End Sub