• Home
 · 
• String Manipulation
 · 
• Character counter

Character counter

A FAST and EASY way to count the number of occurrences of one string within another! Please vote for this tip if you find it useful.

Rate Character counter

• 1
• 2
• 3
• 4
• 5

(5(5 Vote))

Private Sub Test()
Const mystr = "This is a test of the split function"
' returns 6
Debug.Print Occurs(mystr, "t")
End Sub
Public Function Occurs(ByVal strtochk As String, ByVal searchstr As String) As Long
' remember SPLIT returns a zero-based array
Occurs = UBound(Split(strtochk, searchstr)) + 1
End Function