seprate and store string in arrays

[ilyaskazi]

i receive the string through txtbox= "jack;dave;john"

In above string there are 3 names seprated by 2 semicolon

I want to store names in array and display msgbox saying...

array="jack"
msgbox (array)

array="dave"
msgbox (array)

array="john"
msgbox (array)

plz note: string names can be in any numbers seprated by column.
Also it can be only one name with no semicolon.

 

[jindon]

If you are on xl200 or later

Code:

 

[ilyaskazi]

no i don't want it to put in one msgbox.

there should be each msgbox to display for each-n-every names seprated

 

[DM Unseen]

use the VBA split function.

DM Unseen

 

[jindon]

Then

Code:
--------------------

Dim x,i
x=split("jack;dave;john",";")
For i = Lbound(x) To Ubound(x)
msgbox x(i)
Next

 

[ilyaskazi]

thanku jindon,

it is solved and working perfect..