I have a requirement with a macro that it should post to consecutive adjacent columns. I am a complete novice in VBA.


Let me explain: I take the user input using a Userform Textbox.


Next after clicking on the submit button, It should post the text inputted to Column A with 200 characters per row.


Suppose 500 characters were inputted into the Userform Text box, after clicking on the submit button, A1 must have 200 characters, A2 must have 200 characters and A3 must have 100 characters.

Please help me out with this as earlly as possible.

So far I have tried the Split function but to avail since it uses a delimiter to differentiate characters and not the number of characters.