Word Wrap In UserForm TextBox
 

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

Word Wrap In UserForm TextBox
 

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

Regards,
Peter T

"Minitman" wrote in message
...
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

Word Wrap In UserForm TextBox
 

On Jun 30, 9:06*am, Minitman wrote:
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

Word Wrap In UserForm TextBox
 

Hey Peter,

That works perfectly, thank you.

-Minitman



On Mon, 30 Jun 2008 07:46:41 +0100, "Peter T" <peter_t@discussions
wrote:

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

Regards,
Peter T

"Minitman" wrote in message
.. .
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

Word Wrap In UserForm TextBox
 

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


On Mon, 30 Jun 2008 00:11:44 -0700 (PDT), Shazi
wrote:

On Jun 30, 9:06*am, Minitman wrote:
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