Parse string

[loopoo]

Hello!

I am quite new to Excel VBA. Can anyone please help me with this issue
I want to parse a string character by character just like an array.

Is there a function for that??

Thanks in advance,
Chri

 

[Ardus Petus]

dim i as integer
dim str as string
dim car as string
for i = 1 to len(str)
car = mid(str,i,1)
msgbox car
next i


Cordialement,

 

[loopoo]

Thanks a lot for your help.

That was exactly what I was looking for.

Chris.