在 VBA 中 找字串 在一個變數出現次數

VBA - count substrings in string

string="ABBBBACCC"
goal=2 'number of occurances of "A"

MsgBox Len(string) - Len(Replace(string, "A", ""))

SOURCE : http://www.mrexcel.com/forum/excel-questions/234028-visual-basic-applications-count-substrings-string.html