Parse string

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,
Chris

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,
--
AP


"loopoo" <[email protected]> a écrit dans
le message de news:[email protected]...
>
> 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,
> Chris
>
>
> --
> loopoo
> ------------------------------------------------------------------------
> loopoo's Profile:
http://www.excelforum.com/member.php...o&userid=28792
> View this thread: http://www.excelforum.com/showthread...hreadid=529118
>

Thanks a lot for your help.

That was exactly what I was looking for.

Chris.