Word Wrap In UserForm TextBox

[Minitman]

Greetings,

I have a couple of TextBoxes being used as memo fields. I don't want
the text to wrap when I copy the contents to a cell on the worksheet.
I would however, like to see the text inside of the TextBox wrap at
the border of the TextBox.

I have WordWrap turned on in the properties box for the TextBox, but
it doesn't seem to make any difference.

Short of manually inserting Chr(10)'s at the break points of the text,
is there anyway to get the text to word wrap inside of the TextBox?

Anyone have any ideas or suggestions?

Any help will be appreciated.

-Minitman

 

[Peter T]

Set both the TextBox's MultiLine and WordWrap properties to True

Regards,
Peter T

 

[Shazi]

Greetings,

I have a couple of TextBoxes being used as memo fields.  I don't want
the text to wrap when I copy the contents to a cell on the worksheet.
I would however, like to see the text inside of the TextBox wrap at
the border of the TextBox.

I have WordWrap turned on in the properties box for the TextBox, but
it doesn't seem to make any difference.

Short of manually inserting Chr(10)'s at the break points of the text,
is there anyway to get the text to word wrap inside of the TextBox?

Anyone have any ideas or suggestions?

Any help will be appreciated.

-Minitman

Hi,

also you need to change InterKeyBehaviour textbox property to TRUE
then you can user textbox as a memo shape

regards.

shahzad

 

[Minitman]

Hey Peter,

That works perfectly, thank you.

-Minitman

 

[Minitman]

Hey Shazi,

Thanks for the reply.

I'm not sure what the "InterKeyBehaviour textbox property" is, it's
not in the TextBox properties box.

For what I am trying to do, Peter's solution appears to be all that is
needed.

I am a bit confused as to what a "memo shape" is and why I would want
one.

Could you explain?

-Minitman