Retrieving Rich Text from a RTF Text box in a User Form

		Microsoft Office Forums > Microsoft Word > Word VBA
Retrieving Rich Text from a RTF Text box in a User Form

06-19-2014, 12:18 PM

Cosmo

Windows Vista Retrieving Rich Text from a RTF Text box in a User Form

Office 2007

Competent Performer

Join Date: Mar 2012

Posts: 240

Quote:

Originally Posted by jpb103

I get a type mismatch when I try this code.

Code:

        Set oRng = DescriptionBox.TextRTF
        oRow.Cells(1).Range.FormattedText = oRng

Where DescriptionBox is my RTF text box and oRow.Cells(1).Range.Text is where I'd like to put the contents of said RTF text box.

This might work:

Code:

 
oRow.Cells(1).Range.FormattedText  = DescriptionBox.TextRTF

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rich text/Plain text Content Controls in Template	michael.fisher5	Word	9	11-19-2014 06:36 AM
Rich Text Content Control - Allow User Formatting	keithacochrane	Word	1	05-28-2012 05:06 PM
How to I make text Bold in a User Form -Visual Basic	gurp99	Word VBA	11	03-12-2012 04:05 PM
My plain text post got converted to rich text in a reply, how to convert it back?	david.karr	Outlook	0	01-05-2012 09:46 AM
Templates: automatic text generation from Rich Text content control	Chickenmunga	Word	0	10-01-2008 11:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:33 PM.