MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Differents types of texts into a textBox

Posted by Barbara Hurel on December 13, 2001 6:31 AM

I had the following problem...
I'm working in Excel 97 with vba inside an Intranet. My restrictions are that a i can`t use activeX controls.
I need to construct a textbox where it can be possible to write some parts of the text in Bold, other parts in Italic and others in Normal text. The idea is to have a text box an three buttons with labels Bold, Italic and Normal where i can write and select some parts of the text to format depending the button (Bold, italic o normal) i press.
For any idea a lot of thanks

Posted by Lucky on December 13, 2001 8:06 AM

Maybe use the text box on the Drawing toolbar as alternative???

Posted by Joe Was on December 13, 2001 8:07 AM

Don't use a text box, use a custom user form and add your buttons and text boxes to your form, if you need to, you can break one text box in to connected sub-boxes each with a different format. JSW