Multiline textbox to multiple data rows.

[gundesvan]

Hi all,

I have a textbox that i load a txt file into, after that i want to get all the lines in the textbox to separate rows on a different sheet.
The target cell starting cell is A1 and i want it to overwrite any existing data each time.

I have tried to google it a bit, but aren't really getting anywhere.

Any advises?

Thanks.

[dOOb]

Is pasting the text from your text file directly into the sheet not an option?

[gundesvan]

No not really, I want the workbook to be as automated as possible.

Basically it is a price calculations sheet, where user can export the relevant data (as model code and so on), and at later time re-import it to see the configuration, price etc.

[dOOb]

When you say you load text file into text box - how do you do it?

Not sure if what you are asking is possible with a textbox, i think listbox would be more suitable for what you're describing here. Listbox has the .RowSource property which you can link to the data in your spreadsheet

[gundesvan]

Hi load it with the code (that i just got from "logit" here on the forum);

Please Login or Register  to view this content.

So that part works fine.
Now i want all the lines that are in the textbox to be copied to another sheet starting at A1 for line 1, A2 for line 2 etc.
Always start in A1 and rewrite old text.

[SPARKY347]

So this code will allready have the words set into multiple lines?

[SPARKY347]

it would honestly help if you could show somehow what the data looks like after it has been loaded into the textbox?

[bakerman2]

Try this.

Please Login or Register  to view this content.

[gundesvan]

That did it bakerman2, thanks!