Results 1 to 2 of 2

Thread: Splitting userform text onto different rows

  1. #1
    Junior Member
    Join Date
    Feb 2015
    Posts
    2
    Rep Power
    0

    Splitting userform text onto different rows

    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.

  2. #2

Similar Threads

  1. Replies: 6
    Last Post: 08-11-2014, 05:41 PM
  2. VBA To Extract Certain Rows From A Text File
    By Bogdan in forum Excel Help
    Replies: 4
    Last Post: 08-31-2013, 06:57 PM
  3. Splitting and merging files with VBA
    By tryingtocode in forum Excel Help
    Replies: 1
    Last Post: 05-23-2013, 10:37 PM
  4. Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  5. Scrolling Marquee text on Userform
    By Mechanic in forum Excel Help
    Replies: 1
    Last Post: 12-08-2011, 07:24 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •