For a Textbox with:

The quick brown fox
The quick brown fox
The quick brown fox


You want the cell to look like

The quick bro
The quick bro
The quick bro

I don't believe you can achieve that. Wrap Text would wrap the text and if
you turn that off, then you would not have multiple lines in the cell.

--
Regards,
Tom Ogilvy

"Jim May" <jmay@cox.net> wrote in message
news:Zrx4f.1130$mV4.774@dukeread02...
> 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
>
>