Need to divide text equally from a userform text field and paste into a range of cells in excel

[achar]

Hi All

It is known that the max characters that excel can display in a cell is 1024.
How ever, I am trying to paste data which has around 10,000 characters in it. Since it cant be directly copy pasted, i have created a userform and have made a textbox = Userform1.TextBox1.

Question is once the data is entered into the Userform1.TextBox1, how do I split it to equal partitions and paste it to a Range of cells say the whole of Column A.

So far, I used the code

Transpose(split(Textbox1, chr(30)))

but when run, the values show as "False" in each cell.
Please provide assistance with this. I need a code that will divide the text and paste it into a range of cells.

Thanks in advance

 

[Norie]

Can you post the rest of that line of code?