WRAPPING TEXT IN A TEXT BOX !
 

I have created a Text Box in my worksheet using the VBA toolbar.
Although I set word wrap under properties to true, when I type text in
the Text Box the text will not wrap. It only stays on one continuous
long line. I want my text/words to wrap in the text box.Any help would
be appreciated.

Thanks.
Jay Dean



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

WRAPPING TEXT IN A TEXT BOX !
 

Did you set multiline to True. If not, word wrap is ignored.

--
Regards,
Tom Ogilvy

"jay dean" wrote in message
...

I have created a Text Box in my worksheet using the VBA toolbar.
Although I set word wrap under properties to true, when I type text in
the Text Box the text will not wrap. It only stays on one continuous
long line. I want my text/words to wrap in the text box.Any help would
be appreciated.

Thanks.
Jay Dean



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

WRAPPING TEXT IN A TEXT BOX !
 

Oh I see. Thanks, Ogilvy !

Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!