Userform Textbox multiline Vs format in worksheet

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

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
>
>

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
>>
>>
>
>

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
> >>
> >>
> >
> >
>
>

That nailed it Tom,
Thanks,

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:eWictRp0FHA.3336@TK2MSFTNGP12.phx.gbl...
> 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
>> >>
>> >>
>> >
>> >
>>
>>
>
>