Displaying single line of text on several lines in a textbox

Hello

This might be a little confusing so bear with me. I want a single line textbox (i.e. MultiLine = False) because I don't want the user to be able to manually change line nor do I want the text displayed to actually contain newlines. I want the textbox to display the one line of text on several lines when it runs out of space on the first line.

Ideas?

Thanks in advance

Can't you set the wordwrap property to true?

Originally Posted by arthurbr

Can't you set the wordwrap property to true?

Already True, doesn't seem to effect the lines.

.AutoSize = True ?

Originally Posted by snb

.AutoSize = True ?

Not what I'm looking for, I want the size of the textbox to remain the same but when the string entered reaches the end of the textbox I want it to automatically move to the next line. I don't, however, want the string to contain any actual newlines.

Originally Posted by romperstomper

Where is the textbox? If on a sheet, what kind is it (i.e. how did you create it)?

It's in a userform. I use the MSForms.TextBox control. I created it using the toolbox.