vba怎么遍历一条字符串?

崩坏的肥皂

菜鸟纠结一下午了,假设A="ABC"
用For Each i In A,希望每次循环i结果分别为"A","B","C"
但是系统说类型不匹配,这要怎么办啊

liulang0808

For  i = 1 to  len(A)
msgbox mid(a,i,1)
next i

崩坏的肥皂

我该如何遍历字符串A分别得到"A","B","C"?

huang1314wei

崩坏的肥皂 发表于 2019-6-12 22:03
我该如何遍历字符串A分别得到"A","B","C"?

2楼给你答案了

崩坏的肥皂

liulang0808 发表于 2019-6-12 22:03
For  i = 1 to  len(A)
msgbox mid(a,i,1)
next i

谢谢老师,我改一下就可以这样遍历出要的结果了
For i1 = 1 To Len(A)
    i = Mid(A, i1, 1)