I have text inputted in a textbox on a form. The text wraps in the textbox.
Code then places the text string from the textbox into a cell on a worksheet.
I turn off wrap text in the cell to keep the row height from changing (the
text never gets looked at in the cell). Other code takes the text string
from the cell and displays it a list box (which I find does not have the
ability to deal with text wrapping). If I make the user use alt-enter to
enter multiline text in the original textbox I can with code find the line
feeds (chr(10)) and put the text string in multiple lines in the listbox. Is
there a way to accomplish all this without requiring alt-enter when typing
text into the textbox. Or another way to say this is there a way to find
where text wraps in a textbox when alt-enter is not used.
--
russ