Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Red face Unanswered: putting/dividing a text entry into columns

    I've been able to change a text entry into columns by using command Data - text to column in Excel, but I can't find a way to use it in VBA. Anyone can help me?
    Example : the input is ABCDEFGHIJ and i want to put them in ten separate columns automatically from an input box. Thanks before.

  2. #2
    Join Date
    Jan 2004
    Location
    Newcastle UK
    Posts
    10
    I just quickly stuck together an example ... is that what ya were looking for?
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Posts
    3

    Talking

    GREAT! Just what I've been looking for, thanks. My regard from Indonesia

Posting Permissions

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