Hey all,

My first post here and after alot of Excel work I finally have a VB
problem thats got me stumped!

So, I have a Listbox that when a save button is pressed, dumps th
values it holds into a cell, with each value separated by "," as
delimiter. The output looks something like this:

,itemA,itemB,itemC, and so on. Each entry is a set phrase so the lengt
or content doesnt change, just the contents of the cell (according t
which entries the user has put into the listbox)

What I need is a routine that will take that output into a string, the
put the words that are between the "," into their own strings or cell
like a delimiter or separator. Is this possible? My programming so fa
isnt set in stone so some changes are possible, if anyone can sugges
anything!! :)

Thanks in advance,
Fyn

--
fyn
-----------------------------------------------------------------------
fynn's Profile: http://www.excelforum.com/member.php...fo&userid=3542
View this thread: http://www.excelforum.com/showthread.php?threadid=55193