Parsing string from textbox

[jcg]

I have a textbox that accepts a series of states (Two initials) separated by commas. I then want to populate an array with the individual states listed in the textbox (MA,WI,MI to array(0)=MA, array(1)=WI, array(2)=MI etc.) What is the VBA method that allows me to parse a string in this fashion?

Thanks

 

[Greg Truby]

In a bit of a hurry - so will be brief. If I recall correctly the VBA function you seek is called SPLIT().

 

[jcg]

Thanks Greg