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

use the VBA split function.

DM Unseen

thanku jindon,

it is solved and working perfect.. :)


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

If you are on xl200 or later

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

Dim x
x=split("jack;dave;john",";")
msgbox Join(x,vbLf)
--------------------


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