In Userform1 I have a textbox (multiline = True; Word wrap = False) where I
need to enter 3 or 4 lines of text (I've implemented a scrollbar to
accomodate if the text is greater than the size of the box).
As I copy the textbox content to my underlying sheet1 the Comments Column
causes my row to quadruple in size. How can I have my sheet NOT look this
way;
meaning the text beyond the normal 1" of the column doesn't need to be
visible..
How can I acheive this?
TIA,
Jim