After you write your data:

Columns("Q:Q").wraptext = False
Columns("Q:Q").ColumnWidth = 11.43

--
Regards,
Tom Ogilvy


"Jim May" <jmay@cox.net> wrote in message
news:y%y4f.1134$mV4.672@dukeread02...
> Sorry for any misunderstnding, but
> I want my Column Widths to be 11.43
> For a Textbox with:
>
> The quick brown fox
> The quick brown fox
> The quick brown fox
>
> You want the cell (worksheet) to look like
> Row Q (col) R (col)
> 50 The quick bro Virginia
>
> Where cell Q50 contains The quick brown fox The quick brown fox The quick
> brown fox
> and R50 is Virginia (State Column).
> Thanks,
> Jim
>
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> news:enTHJdo0FHA.404@TK2MSFTNGP09.phx.gbl...
> > 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
> >>
> >>
> >
> >
>
>