Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171373

From BetaArchive Wiki
Knowledge Base

Article ID: 171373

Article Last Modified on 10/10/2006


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q171373


If you use the TextRTF property for a RichTextBox ActiveX control to populate a worksheet cell, Rich Text Format (RTF) code may appear in the cell.


This problem occurs because the TextRTF property returns the text of a RichTextBox control, including all RTF code, and Microsoft Excel cannot interpret RTF code that is copied to a cell with a macro. This is true even though you can manually apply rich text formatting in a worksheet cell.


You cannot use the TextRTF property to place the contents of a RichTextBox control without the RTF code into a worksheet cell. Instead, use the Text property to return the contents of a RichTextBox control to a worksheet cell. However, note that the text property does not support rich text formatting.


The RichTextBox control is part of a collection of ActiveX controls that is included with the Office Developers Edition compact disc (CD). It provides properties you can use to apply formatting to any portion of text within the control. To change the formatting of text, you must select it first. Only selected text can be assigned character and paragraph formatting. By using these properties, you can make text bold or italic, change the color, and create superscript and subscript text. You can also adjust paragraph formatting by setting both left and right indents, and you can create hanging indents.

For additional information, please see the following articles in the Microsoft Knowledge Base:

170232 XL97: Printing Formatted Text from a RichTextBox Control

165450 XL97: Error Inserting ActiveX Object in a Worksheet


For more information about the RichTextBox control, add a RichTextBox control to a UserForm, select the control, and then press F1.

Additional query words: XL97

Keywords: kbprogramming KB171373