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

--
loopo
-----------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...fo&userid=2879
View this thread: http://www.excelforum.com/showthread.php?threadid=52911

Parse string
 

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" a écrit dans
le message de ...

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

Parse string
 

Thanks a lot for your help.

That was exactly what I was looking for.

Chris.


--
loopoo
------------------------------------------------------------------------
loopoo's Profile: http://www.excelforum.com/member.php...o&userid=28792
View this thread: http://www.excelforum.com/showthread...hreadid=529118