Multiline User Input

[avrahamroos]

Hi All,

First posting on this forum. I usually ask my questions on Mr.Excel and until now have received quick and good answers but the following question did nt get any reply.

I need the option for a user to input two long multiline texts which will be pasted into Excel in two different columns. Text 1 in sheet3 column A and text 2 in sheet1 column A.

But I cannot find any option for multiline user input boxes.

Can anyone please help out?

 

[bobhc]

Can the users just type in to the cells, if yes just set the word wrap on in those cells, depending on the size of text input the row hight could end up quite large.

 

[avrahamroos]

I need each line in a new cell. Not everything in one cell.

In principle the user could copy from word document and past into cell A1 and the text would nicely fill in in column A line after line in cell after cell. But because the two texts go in two different places I do not want the user to paste directly into the sheets themselves.

 

[AVK]

can you upload sample file with manually enter required result.

 

[avrahamroos]

I have solved the problem.

Thank you.