seprate and store string in arrays

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.

If you are on xl200 or later

Please Login or Register  to view this content.

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

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

Then

Please Login or Register  to view this content.

use the VBA split function.

DM Unseen

thanku jindon,

it is solved and working perfect..