Userform Text box format

[windsurfit]

Hi,

I'm using text boxes in a Userform, and I want the text/data being entered into the box setup to wrap within the box, rather than continuing to go to the right after the entry has exceeded the length of the box.

Basically a way to add data of any length to the text box, even written sentences, but will wrap once the right margin/border is "hit". My Text box is being used as a customer contact notes box entry and is large enough to accommodate multiple sentences of data. The large data entry seems to display fine on the actual sheet with the Wordwrap checked under sheet format so that is good.

FYI-Under the specific Text box properties... I already have the Multiline set to "true" and the Wordwrap also set to true but this doesn't accomplish it. My max Length characters is set at 95 for the width of the Userform Text box single line size.



Thanks in advance!

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1062215-userform-text-box-info.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.