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.


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=383041