An easy one for the gurus. texbox.value into multiple lines of Auto Shape.

[vonRobbo]

Good afternoon,

I have a script where the text from a textbox is put into an autoshape.

I have autofit=true on the shape, which makes the shape stretch to fit the text.

At the moment if the textbox.value is quite long, my autoshape winds up being very wide and short.

I'd like to do something like:

Please Login or Register  to view this content.

If I could get seperate whole words, that would be perfect.

Alternatively, is there a way to fix the width of an AutoShape and autosize the height to fit the text?

Or, is there a way to autofit the text to the box rather than fit the box to the text?

Any assistance you can provide is appreciated.

[millz]

Maybe this

Please Login or Register  to view this content.

[vonRobbo]

This works really well, but for some reason I'm getting box characters at the end of my lines like this...

Boxes.JPG

Maybe because I'm trying to put the text into an AutoShape. Any ideas?

[vonRobbo]

Got it. Just had to change vbCrLf to vbLf

Thank you!!