ayanami365 的思路正确,但是忽略了当S为空的时候这一特殊情况。
写了一个函数给您调用,这样你可以在任意字符串中查找某字符的个数,调用格式CharNum(A,B),其中A是字符串,B是要查找的字符:
Function CharNum(ByVal strInput As String, ByVal strChar As String) As Long
Dim S() As String
If Len(Trim(strInput)) = 0 Then
CharNum = 0
Else
S = Split(strInput, strChar)
CharNum = UBound(S)
End If
End Function
Private Sub Command1_Click()
Dim A As String, C As String
A = "1,2"
C = ","
MsgBox CharNum(A, C)
End Sub
温馨提示:答案为网友推荐,仅供参考