再想一个比较不正常的方法:
Dim Str As String, i As Integer
Dim Temp() As String
Str = "abcdefghijkolmnkqposcihugbuyvgfuxwncsaoungyzouyfxtncdjixzidnmizaxdsjgcnxhkbcaf"
For i = 65 To 90
Temp = Split(UCase(Str), Chr(i))
MsgBox "字母 " & Chr(i) & " 共有 " & Format(UBound(Temp)) & " 个"
Next i
Private Sub Command1_Click()
On Error Resume Next
Dim i As Long, temp As String, all As New Collection
For i = 1 To Len(Text1.Text)
temp = Mid(Text1.Text, i, 1)
all.Add temp & "出现了: " & UBound(Split(Text1.Text, temp)) & " 次!", temp
Next
For i = 1 To all.Count
Debug.Print all(i)
Next
End Sub
Private Sub Form_Load()
Text1.Text = "fantasyfan (fantasyfan)"
End Sub