pcsparky
12-05-2009, 10:43 AM
I want the user to be able to use the enter button in a multiline textbox, which works fine.
But when I send that data to a merged cell, Excel doesn't recognise the use of the enter button for a new line and creates a small square. The font is Arial but others produce same result.
I know that you can use Alt+Enter in a cell but is there any way around this when sending the data?
Basically I want the user to be able to type grammatically and be shown accordingly in the cell.
I have also tried sending the text to a sheet textbox but that displays the line break as the new paragraph symbol.
But when I send that data to a merged cell, Excel doesn't recognise the use of the enter button for a new line and creates a small square. The font is Arial but others produce same result.
I know that you can use Alt+Enter in a cell but is there any way around this when sending the data?
Basically I want the user to be able to type grammatically and be shown accordingly in the cell.
I have also tried sending the text to a sheet textbox but that displays the line break as the new paragraph symbol.