08-17-2012, 05:14 PM
(This post was last modified: 08-17-2012, 05:14 PM by souvikghosh_diatm.)
I don't think a function is required for this... its as simple as follows which calculate the occurrences as well....
Code:
strString = "ABC is good at testing.ABC is working on PC.ABC is playing games."
ArrstrString = Split (strString, "ABC")
strCount = Ubound(ArrstrString)
msgbox ("No of occurrences: "&strCount)